-
Notifications
You must be signed in to change notification settings - Fork 0
/
jobs_performance
1837 lines (1779 loc) · 180 KB
/
jobs_performance
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
function copyJobURL20() {
var spreadsheet = SpreadsheetApp.getActive();
/*Year*/
spreadsheet.getRange('A2').setValue('2020');
/*January*/
spreadsheet.getRange('B3').setValue('January');
/* #2322 Coffin Golf Course */
spreadsheet.getRange('C4').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!B3")');
spreadsheet.getRange('D4').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!B5")');
spreadsheet.getRange('E4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!B2")');
spreadsheet.getRange('F4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!B4")');
spreadsheet.getRange('G4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!B7")');
spreadsheet.getRange('H4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('I4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('J4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('K4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('L4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('M4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('N4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('O4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!N4") ');
spreadsheet.getRange('P4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!N6") ');
spreadsheet.getRange('Q4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!S195") ');
spreadsheet.getRange('R4').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Asr34U3UOjJ4DQWaxkWRZTidFBqj_A-aSmz1sPi3ovY/edit#gid=1563544383","JobCostTracker!U195") ');
spreadsheet.getRange('S4').activate();
spreadsheet.getCurrentCell().setFormula('=J4-(K4+L4+M4+N4+04+P4)');
spreadsheet.getRange('T4').activate();
spreadsheet.getCurrentCell().setFormula('=S4/J4');
/* #2323 Co-Live Bloomington */
spreadsheet.getRange('C5').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!B3")');
spreadsheet.getRange('D5').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!B5")');
spreadsheet.getRange('E5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!B2")');
spreadsheet.getRange('F5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!B4")');
spreadsheet.getRange('G5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!B7")');
spreadsheet.getRange('H5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!F2")');
spreadsheet.getRange('I5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!F4")');
spreadsheet.getRange('J5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!F6")');
spreadsheet.getRange('K5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!J2")');
spreadsheet.getRange('L5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!J4")');
spreadsheet.getRange('M5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!J6")');
spreadsheet.getRange('N5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!N2")');
spreadsheet.getRange('O5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!N4") ');
spreadsheet.getRange('P5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!N6") ');
spreadsheet.getRange('Q5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!S200") ');
spreadsheet.getRange('R5').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/13b_lCq09RIPrV8o_n29LZJTuMvTYyE9UU4K9O1H7NSU/edit#gid=1138634574","JobCostTracker!U200") ');
spreadsheet.getRange('S5').activate();
spreadsheet.getCurrentCell().setFormula('=J5-(K5+L5+M5+N5+05+P5)');
spreadsheet.getRange('T5').activate();
spreadsheet.getCurrentCell().setFormula('=S5/J5');
/* #2324 Switchyard Apartments */
spreadsheet.getRange('C6').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!B4")');
spreadsheet.getRange('D6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!B5")');
spreadsheet.getRange('E6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!B2")');
spreadsheet.getRange('F6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!B3")');
spreadsheet.getRange('G6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!B7")');
spreadsheet.getRange('H6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('I6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('J6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('K6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('L6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('M6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('N6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!N2") ');
spreadsheet.getRange('O6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!N4") ');
spreadsheet.getRange('P6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!N6") ');
spreadsheet.getRange('Q6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!S192") ');
spreadsheet.getRange('R6').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1XiOk_j_UqBSXmv2-N6yWyviy_vjNAhnG04D6_SPxH2o/edit#gid=1563544383","JobCostTracker!U192") ');
spreadsheet.getRange('S6').activate();
spreadsheet.getCurrentCell().setFormula('=J6-(K6+L6+M6+N6+06+P6)');
spreadsheet.getRange('T6').activate();
spreadsheet.getCurrentCell().setFormula('=S6/J6');
/* #2325 Avon Fire Station */
spreadsheet.getRange('C7').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!B3")');
spreadsheet.getRange('D7').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!B5")');
spreadsheet.getRange('E7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!B2")');
spreadsheet.getRange('F7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!B4")');
spreadsheet.getRange('G7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!B7")');
spreadsheet.getRange('H7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('I7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('J7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('K7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('L7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('M7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('N7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('O7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!N4") ');
spreadsheet.getRange('P7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!N6") ');
spreadsheet.getRange('Q7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!S193") ');
spreadsheet.getRange('R7').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/19EJyQZtHCF3PcmnZB1IjhIOlB57vmvhyRzE1JjjIw1s/edit#gid=1563544383","JobCostTracker!U193") ');
spreadsheet.getRange('S7').activate();
spreadsheet.getCurrentCell().setFormula('=J7-(K7+L7+M7+N7+07+P7)');
spreadsheet.getRange('T7').activate();
spreadsheet.getCurrentCell().setFormula('=S7/J7');
/* #2326 JD Sports Greenwood Storage */
spreadsheet.getRange('C8').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!B3")');
spreadsheet.getRange('D8').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!B5")');
spreadsheet.getRange('E8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!B2")');
spreadsheet.getRange('F8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!B4")');
spreadsheet.getRange('G8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!B7")');
spreadsheet.getRange('H8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('I8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('J8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('K8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('L8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('M8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('N8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('O8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!N4") ');
spreadsheet.getRange('P8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!N6") ');
spreadsheet.getRange('Q8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!S192") ');
spreadsheet.getRange('R8').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O2TAsT6qYuInxVswKRfNNPdGLJ3kT4HJFSRAg3YUJT0/edit#gid=1563544383","JobCostTracker!U192") ');
spreadsheet.getRange('S8').activate();
spreadsheet.getCurrentCell().setFormula('=J8-(K8+L8+M8+N8+08+P8)');
spreadsheet.getRange('T8').activate();
spreadsheet.getCurrentCell().setFormula('=S8/J8');
/* #2327 Duke Plainfield */
spreadsheet.getRange('C9').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!B3")');
spreadsheet.getRange('D9').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!B5")');
spreadsheet.getRange('E9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!B2")');
spreadsheet.getRange('F9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!B4")');
spreadsheet.getRange('G9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!B7")');
spreadsheet.getRange('H9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('I9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('J9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('K9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('L9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('M9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('N9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('O9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!N4") ');
spreadsheet.getRange('P9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!N6") ');
spreadsheet.getRange('Q9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!S193") ');
spreadsheet.getRange('R9').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bdUJW7RccvHxWtorD2N3cJqv2KTDtqzSiqbEFHW39VA/edit#gid=1563544383","JobCostTracker!U193") ');
spreadsheet.getRange('S9').activate();
spreadsheet.getCurrentCell().setFormula('=J9-(K9+L9+M9+N9+09+P9)');
spreadsheet.getRange('T9').activate();
spreadsheet.getCurrentCell().setFormula('=S9/J9');
/* #2328 Tribute Hotel Downtown */
spreadsheet.getRange('C10').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!B3")');
spreadsheet.getRange('D10').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!B5")');
spreadsheet.getRange('E10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!B2")');
spreadsheet.getRange('F10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!B4")');
spreadsheet.getRange('G10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!B7")');
spreadsheet.getRange('H10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('I10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('J10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('K10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('L10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('M10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('N10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('O10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!N4") ');
spreadsheet.getRange('P10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!N6") ');
spreadsheet.getRange('Q10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!S192") ');
spreadsheet.getRange('R10').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1UH9Ou-Z-RNJx-hAUcAEFWiNYNzugXmt6SXpxTW5vtDY/edit#gid=1563544383","JobCostTracker!U192") ');
spreadsheet.getRange('S10').activate();
spreadsheet.getCurrentCell().setFormula('=J10-(K10+L10+M10+N10+010+P10)');
spreadsheet.getRange('T10').activate();
spreadsheet.getCurrentCell().setFormula('=S10/J10');
/* #2329 JC Partners Dumpster */
spreadsheet.getRange('C11').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!B3")');
spreadsheet.getRange('D11').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!B5")');
spreadsheet.getRange('E11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!B2")');
spreadsheet.getRange('F11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!B4")');
spreadsheet.getRange('G11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!B7")');
spreadsheet.getRange('H11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('I11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('J11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('K11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('L11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('M11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('N11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('O11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!N4") ');
spreadsheet.getRange('P11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!N6") ');
spreadsheet.getRange('Q11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!S192") ');
spreadsheet.getRange('R11').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1H3r8O6yX_vVz4KL9oOcDQVdxeSUfcM30bqlYOpPBnno/edit#gid=1563544383","JobCostTracker!U192") ');
spreadsheet.getRange('S11').activate();
spreadsheet.getCurrentCell().setFormula('=J11-(K11+L11+M11+N11+011+P11)');
spreadsheet.getRange('T11').activate();
spreadsheet.getCurrentCell().setFormula('=S11/J11');
///February
spreadsheet.getRange('B12').setValue('February');
///2330 Chipotle West Lafayette
spreadsheet.getRange('G13').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C13').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1OqkP-gXH29pcFWEmKAG0ubyZv868Y9hrLsVeRhqcFJU/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R13').activate();
spreadsheet.getCurrentCell().setFormula('=I13-(J13+K13+L13+M13+N13+013)');
spreadsheet.getRange('S13').activate();
spreadsheet.getCurrentCell().setFormula('=R13/I13');
///2331 Korger J248
spreadsheet.getRange('G14').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!S194")');
spreadsheet.getRange('Q14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!U194")');
spreadsheet.getRange('F14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C14').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1B4G--alEpxQujCB8r-weIupI_yUSlAKp21BLTQ8AID4/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R14').activate();
spreadsheet.getCurrentCell().setFormula('=I14-(J14+K14+L14+M14+N14+014)');
spreadsheet.getRange('S14').activate();
spreadsheet.getCurrentCell().setFormula('=R14/I14');
///2332 Huntington Bank High School Rd
spreadsheet.getRange('G15').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C15').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AQkHOqfgP7KgApw-8lkcBFzOsrLgWE3vrWaNifqtA1g/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R15').activate();
spreadsheet.getCurrentCell().setFormula('=I15-(J15+K15+L15+M15+N15+015)');
spreadsheet.getRange('S15').activate();
spreadsheet.getCurrentCell().setFormula('=R15/I15');
///2333 Huntington Bank Lafayette Square Rd
spreadsheet.getRange('G16').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C16').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1DA-UM4FL6rJWUhWu-vxUUPUIfLJU4QO78QgupiTw0w0/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R16').activate();
spreadsheet.getCurrentCell().setFormula('=I16-(J16+K16+L16+M16+N16+016)');
spreadsheet.getRange('S16').activate();
spreadsheet.getCurrentCell().setFormula('=R16/I16');
///2334 Huntington Bank Rd Willow Lake Rd
spreadsheet.getRange('G17').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C17').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Y5RR5-85NXj23b55WV670a5E8-2ZWXnkp17WEyB6RKM/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R17').activate();
spreadsheet.getCurrentCell().setFormula('=I17-(J17+K17+L17+M17+N17+017)');
spreadsheet.getRange('S17').activate();
spreadsheet.getCurrentCell().setFormula('=R17/I17');
///2335 Mini Mart Centerville IN
spreadsheet.getRange('G18').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C18').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1_3Cx-och-ujuf8IS8eUB8-Y6OAwxuB0JPP-Ketrek3E/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R18').activate();
spreadsheet.getCurrentCell().setFormula('=I18-(J18+K18+L18+M18+N18+018)');
spreadsheet.getRange('S18').activate();
spreadsheet.getCurrentCell().setFormula('=R18/I18');
///2336 Homestar Self Storage
spreadsheet.getRange('G19').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C19').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1PgZRhwM9o9kkXPOGzkjANW4iXYCuQwh2slJt7F_Hoy8/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R19').activate();
spreadsheet.getCurrentCell().setFormula('=I19-(J19+K19+L19+M19+N19+019)');
spreadsheet.getRange('S19').activate();
spreadsheet.getCurrentCell().setFormula('=R19/I19');
///2337 McDonalds 9536 N Meridian Indianapolis
spreadsheet.getRange('G20').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C20').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1z1MLR4xOnF54ygysPgY2u3ZQdAaz3aYj6PChlW_59ZQ/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R20').activate();
spreadsheet.getCurrentCell().setFormula('=I20-(J20+K20+L20+M20+N20+020)');
spreadsheet.getRange('S20').activate();
spreadsheet.getCurrentCell().setFormula('=R20/I20');
///2338 Kroger J827
spreadsheet.getRange('G21').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C21').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1aagnqCU5aEyN0WAeWz3jn7TdDytFR3OZQPdbg7byrCo/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R21').activate();
spreadsheet.getCurrentCell().setFormula('=I21-(J21+K21+L21+M21+N21+021)');
spreadsheet.getRange('S21').activate();
spreadsheet.getCurrentCell().setFormula('=R21/I21');
///2339 McDonalds 2080 E King St.
spreadsheet.getRange('G22').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C22').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1p1FSdm-V_ctjRpHnIG8P10u6p_GupT9F3Zka93y2XYc/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R22').activate();
spreadsheet.getCurrentCell().setFormula('=I22-(J22+K22+L22+M22+N22+022)');
spreadsheet.getRange('S22').activate();
spreadsheet.getCurrentCell().setFormula('=R22/I22');
///2340 King Cole Hotel Model Room
spreadsheet.getRange('G23').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C23').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/17y_5aamON9SnbwgQL5I-yp7RgyQBrLLkC6GbdKccyoY/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R23').activate();
spreadsheet.getCurrentCell().setFormula('=I23-(J23+K23+L23+M23+N23+023)');
spreadsheet.getRange('S23').activate();
spreadsheet.getCurrentCell().setFormula('=R23/I23');
///2341 Simply Chic Greenwood
spreadsheet.getRange('G24').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!S193")');
spreadsheet.getRange('Q24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!U193")');
spreadsheet.getRange('F24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C24').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SyrqtqQrT87bIZdmCsjry1Rys49zGSihJMqCqf72Tmk/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R24').activate();
spreadsheet.getCurrentCell().setFormula('=I24-(J24+K24+L24+M24+N24+024)');
spreadsheet.getRange('S24').activate();
spreadsheet.getCurrentCell().setFormula('=R24/I24');
///2342 Cummins Cerealine
spreadsheet.getRange('G25').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C25').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1yAGXO1gORpaQJreEPcH6vEEKoaARzUKqjwVbFBhbWBk/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R25').activate();
spreadsheet.getCurrentCell().setFormula('=I25-(J25+K25+L25+M25+N25+025)');
spreadsheet.getRange('S25').activate();
spreadsheet.getCurrentCell().setFormula('=R25/I25');
///2343 Azzip Pizza
spreadsheet.getRange('G26').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C26').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iQ6uhwErJYx2VGxUCQm2iDLeNV8DBQzy9ZUqQqPyPdA/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R26').activate();
spreadsheet.getCurrentCell().setFormula('=I26-(J26+K26+L26+M26+N26+026)');
spreadsheet.getRange('S26').activate();
spreadsheet.getCurrentCell().setFormula('=R26/I26');
///2344 McDonalds 4155 S Indianapolis Rd
spreadsheet.getRange('G27').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C27').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1pKbwu3H-yacQ3pJvb7Zj0bQfji9xv36OuHN_WBpkpYQ/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R27').activate();
spreadsheet.getCurrentCell().setFormula('=I27-(J27+K27+L27+M27+N27+027)');
spreadsheet.getRange('S27').activate();
spreadsheet.getCurrentCell().setFormula('=R27/I27');
///2345 Aerial Port Facility Grissom Air Base
spreadsheet.getRange('G28').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C28').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1oxFQe0WzwaiCA-MAeZoDGUEsg6QsbobWN-ZCY4gheMI/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R28').activate();
spreadsheet.getCurrentCell().setFormula('=I28-(J28+K28+L28+M28+N28+028)');
spreadsheet.getRange('S28').activate();
spreadsheet.getCurrentCell().setFormula('=R28/I28');
///March
spreadsheet.getRange('B29').setValue('March');
///2346 Discount Tire
spreadsheet.getRange('G30').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C30').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1GaIcFDLkzZTr6cOjvq_68Q2L1S5J7cgoGcZBB2krYbU/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R30').activate();
spreadsheet.getCurrentCell().setFormula('=I30-(J30+K30+L30+M30+N30+030)');
spreadsheet.getRange('S30').activate();
spreadsheet.getCurrentCell().setFormula('=R30/I30');
///2347 Huntington Bank Washington Interior
spreadsheet.getRange('G31').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C31').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1tp5ODRtvpsLyx2_TxzUUiRRo21P0dm1pY5HPPKWHr7Y/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R31').activate();
spreadsheet.getCurrentCell().setFormula('=I31-(J31+K31+L31+M31+N31+031)');
spreadsheet.getRange('S31').activate();
spreadsheet.getCurrentCell().setFormula('=R31/I31');
///2348 Huntington Bank 11001 Allisonville
spreadsheet.getRange('G32').activate()
.setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!F2")');
spreadsheet.getRange('H32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!F4")');
spreadsheet.getRange('I32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!F6")');
spreadsheet.getRange('J32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!J2")');
spreadsheet.getRange('K32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!J4")');
spreadsheet.getRange('L32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!J6")');
spreadsheet.getRange('M32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!N2")');
spreadsheet.getRange('N32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!N4")');
spreadsheet.getRange('O32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!N6")');
spreadsheet.getRange('P32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!S192")');
spreadsheet.getRange('Q32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!U192")');
spreadsheet.getRange('F32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!B4") ');
spreadsheet.getRange('E32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!B2") ');
spreadsheet.getRange('D32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!B5") ');
spreadsheet.getRange('C32').activate();
spreadsheet.getCurrentCell().setFormula('=IMPORTRANGE("https://docs.google.com/spreadsheets/d/11Q4Ok6cUBx4VEprNLSO2WBta2tVnndZiAEVbApwxLI0/edit#gid=1563544383","JobCostTracker!B3") ');
spreadsheet.getRange('R32').activate();