tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 765752d1643566751-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Snapshot

 | NEW | USED | W/S | Total |  | SALES REPS AVERAGES
Targets |  |  |  |  |  | [NAME] | New Front Gross | New Back Gross | Used Front Gross | Used Back Gross | Total New | Total Used | Total Gross |  |  |  | SOURCES
Writes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEW | USED | DELIVERED | ROI
Dead |  |  |  |  |  | DELIVERED
Del % Of Target
Remaining Locates |  | - | - | - |  | DELIVERED
Factory Orders |  | - | - | -
RDR Counters |  | - | - | - |  | DELIVERED
[NAME] |  |  | -
 |  |  |  |  |  | DELIVERED
Del Front End Gross
Del Back End Gross |  |  |  |  |  | DELIVERED
 |  |  | TOTAL GROSS
Del Avg Front End |  |  |  | - |  | DELIVERED
Del Avg Back End |  |  | - | -
 |  |  |  |  |  | DELIVERED |  |  |  |  |  |  |  |  | AVERAGES
Delivered |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PVR NEW |  | NEW F&I |  | TOTAL NEW
 |  |  |  |  |  | DELIVERED
Total RDR to 110%
 |  |  |  |  |  | F&I AVERAGE |  |  |  |  | Total Back End Gross Delivered |  |  |  | TARGET |  | TARGET |  | TARGET
PENDING |  | Total Gross Including Delivered / Pending |  |  |  | Deliveries Per F&I |  | New | Used | Combined AVG | New | Used | TOTAL
Pending Front End Gross
Pending Back End Gross
 |  |  | TOTAL GROSS |  |  |  |  |  |  |  |  |  |  |  | PVR USED |  | USED F&I |  | TOTAL USED
Pacing Monthly Volume
Pacing Monthly Gross |  |  |  |  |  |  | SALES MANAGER
 |  |  |  |  |  | Writes Per SM |  | AVG Gross New | AVG Gross Used | Back End AVG | Delivered | Total Gross | Pending Gross |  | TARGET |  | TARGET |  | TARGET
Pacing %  Volume Target
Pacing %  Gross Target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERALL F&I
CPO |  |  | Pending New | Pending Used |  |  |  |  |  |  |  |  |  |  | Daily Revenue Needed to Acquire Target
Del CPO Count
CPO Target |  |  |  |  |  | Key Fob |  |  |  | Method of Payment | Finance | Cash | Lease |  | Daily New Volume Needed to Acquire Target
Del CPO Target % |  |  |  |  |  | NEW | USED | TOTAL |  | New
 |  |  |  |  |  |  |  |  |  | Used |  |  |  |  | Daily Used Volume Needed to Acquire Target
Spreadsheet: 787090d1657631101-seperate-large-data-set-across-multiple-tabs-sample-doc
Sheet: A

Invoice Month | Value | Status |  | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00
June | 732773.25 | Complete
A | 732773.2499999999 | 630100 | Complete | 0 | 732773.2499999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | aavryan
Spreadsheet: 0ccbf756-47aa-4c14-9ffd-341f6061dd9e
Sheet: Exhibit A - Transition

Section L - Attachment 7 - Price Schedule
DE-SOL-0003816
Transition (up to 30-days), To be determined
Amendment 000004
Total Contract
 | DPLH |  |  | Labor |  |  | Direct Labor Costs |  |  | Fringe Benefits |  |  | [NAME] |  |  | Onsite Overhead |  |  | Onsite | Total Costs
Cost Element |  |  |  | Straight | Over | Double | Straight | Over | Double |  |  |  |  |  |  |  |  |  | Overhead
 | Straight | Over | Double | Time | Time | Time | Time | Time | Time | Straight | Over | Double | Straight | Over | Double | Straight | Over | Double |  | Straight | Over | Double | Total
Cost Plus Fixed Fee (CPFF) Tasks
***Prime Contractor Labor
Bargaining Employee:
Non-Bargaining Employees:
Subtotal (Provide Subtotals for Each) |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subcontractor Labor (If Applicable)
(Itemize for Each Position)
Subtotal (Provide Subtotals for Each) | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal  Labor Related Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
Other Direct Costs:
Material
Construction
Subtotal Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
G&A (Identify G&A Rate)
Total Proposed Costs
Total Proposal | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
No fee applicable in the transition phase
Spreadsheet: 751944d1634468900-index-match-return-nth-item-if-criteria-met-fifo-stock-valuation-fifo_model_for_many_products_no_vba_v5
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | A
 |  |  | B
 | INSERT ROWS |  | X
 |  |  | C
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | A | 3 | 100 |  | A | 1
 |  |  | A | 6 | 100 |  | A | 4
 |  |  | B | 12 | 20 |  | A | 1
 |  |  | A | 7 | 7 |  | A | 8
 |  |  | A | 8 | 64 |  | B | 10
 |  |  | A | 6 | 1 |  | B | 1
 |  |  | B | 2 | 1 |  | A | 12
 |  |  | A | 2 | 4 |  |  | 12
 |  |  | A | 1 | 10 |  |  | 12
 |  |  | A | 12 | 0 |  |  | 12
 |  |  | A | 0 | 0 |  | B | 1
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | C | 10 | 150
 |  |  | C | 12 | 123
 |  |  | X | 9 | 100
 |  |  | X | 8 | 90
 |  |  | X | 12 | 80
 |  |  | X | 15 | 70 |  | X | 36
 |  |  |  |  |  |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
 |  | 1000 | C | 1 | 9 |  | C | 21
Spreadsheet: 837137d1689873880-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: PPierreL

D | CP | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
False | 75000 | 9.294598048510165 | 18.58919609702033 | 27.88379414553049 | 37.17839219404066 | 46.47299024255083 | 55.76758829106099 | 65.06218633957116 | 74.35678438808132 | 83.65138243659149 | 92.94598048510166 | 102.2405785336118 | 111.535176582122 | 120.8297746306321 | 130.1243726791423 | 139.4189707276525 | 148.7135687761626
False | 76000 | 2.957321941827236 | 5.914643883654471 | 8.871965825481707 | 11.82928776730894 | 14.78660970913618 | 17.74393165096341 | 20.70125359279065 | 23.65857553461788 | 26.61589747644512 | 29.57321941827236 | 32.53054136009959 | 35.48786330192683 | 38.44518524375406 | 41.4025071855813 | 44.35982912740853 | 47.31715106923577
False | 77000 | 1.402459007122735 | 2.80491801424547 | 4.207377021368205 | 5.60983602849094 | 7.012295035613675 | 8.41475404273641 | 9.817213049859145 | 11.21967205698188 | 12.62213106410461 | 14.02459007122735 | 15.42704907835008 | 16.82950808547282 | 18.23196709259555 | 19.63442609971829 | 21.03688510684102 | 22.43934411396376
False | 78000 | 4.885583014478575 | 9.77116602895715 | 14.65674904343573 | 19.5423320579143 | 24.42791507239288 | 29.31349808687145 | 34.19908110135002 | 39.0846641158286 | 43.97024713030718 | 48.85583014478576 | 53.74141315926433 | 58.6269961737429 | 63.51257918822148 | 68.39816220270005 | 73.28374521717863 | 78.1693282316572
False | 79000 | 5.741184579692602 | 11.4823691593852 | 17.22355373907781 | 22.96473831877041 | 28.70592289846301 | 34.44710747815562 | 40.18829205784822 | 45.92947663754082 | 51.67066121723342 | 57.41184579692602 | 63.15303037661862 | 68.89421495631123 | 74.63539953600383 | 80.37658411569643 | 86.11776869538903 | 91.85895327508163
False | 80000 | 0.8439653310452655 | 1.687930662090531 | 2.531895993135796 | 3.375861324181062 | 4.219826655226328 | 5.063791986271593 | 5.907757317316858 | 6.751722648362124 | 7.59568797940739 | 8.439653310452655 | 9.28361864149792 | 10.12758397254319 | 10.97154930358845 | 11.81551463463372 | 12.65947996567898 | 13.50344529672425
False | 81000 | 7.922971677099611 | 15.84594335419922 | 23.76891503129883 | 31.69188670839844 | 39.61485838549805 | 47.53783006259766 | 55.46080173969727 | 63.38377341679688 | 71.3067450938965 | 79.2297167709961 | 87.15268844809572 | 95.07566012519533 | 102.9986318022949 | 110.9216034793945 | 118.8445751564942 | 126.7675468335938
Spreadsheet: 38659d1236798418-summarizing-data-over-several-sheets-bolts-list-r2
Sheet: DETAILS2

BOLT | 20 LG Hex head bolt | 25 LG Hex head bolt | 30 LG Hex head bolt | 35 LG Hex head bolt | 40 LG Hex head bolt | 45 LG Hex head bolt | 50 LG Hex head bolt | 55 LG Hex head bolt | 60 LG Hex head bolt | 65 LG Hex head bolt | 70 LG Hex head bolt | 75 LG Hex head bolt | 80 LG Hex head bolt | 85 LG Hex head bolt | 90 LG Hex head bolt | 95 LG Hex head bolt | 100 LG Hex head bolt | 105 LG Hex head bolt | 110 LG Hex head bolt | 115 LG Hex head bolt | 120 LG Hex head bolt | 125 LG Hex head bolt | 130 LG Hex head bolt | 135 LG Hex head bolt | 140 LG Hex head bolt | 145 LG Hex head bolt | 20 LG socket head csk bolt | 25 LG socket head csk bolt | 30 LG socket head csk bolt | 35 LG socket head csk bolt | 40 LG socket head csk bolt | 45 LG socket head csk bolt | 50 LG socket head csk bolt | 55 LG socket head csk bolt | 60 LG socket head csk bolt | 65 LG socket head csk bolt | 70 LG socket head csk bolt | 75 LG socket head csk bolt | 80 LG socket head csk bolt | 85 LG socket head csk bolt | 90 LG socket head csk bolt | 95 LG socket head csk bolt | 100 LG socket head csk bolt | 105 LG socket head csk bolt | 110 LG socket head csk bolt | 115 LG socket head csk bolt | 120 LG socket head csk bolt | 125 LG socket head csk bolt | 130 LG socket head csk bolt | 135 LG socket head csk bolt | 140 LG socket head csk bolt | 145 LG socket head csk bolt
M8 | 10 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M10 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M12 | 0 | 8 | 22 | 58 | 86 | 63 | 0 | 46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M8CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M10CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M12CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M16CSK | 0 | 0 | 0 | 0 | 0 | 66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M20CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M24CSK | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
M30CSK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 748076d1631878056-if-x-contains-y-then-z-formula-excel-help
Sheet: Sheet1

x | Result |  | Y | z
A blue door | Colour |  | Red | Colour
5 eggs | Number |  | Green | Colour
A green chair | Colour |  | Blue | Colour
6 pairs of shoes | Number |  | 3 | Number
4 dogs | Number |  | 4 | Number
 |  |  | 5 | Number
 |  |  | 6 | Number
Spreadsheet: 159754d1338834490-question-of-finding-a-median-within-data-copy-of-excel-example
Sheet: Sheet1

Ticket Number | Site | Close Date | Network Days Open | Week
1 | Site 1 | 2012-05-31 00:00:00 | 10 |  |  | Site | Week | Median
2 | Site 2 | 2012-06-05 00:00:00 | 1 |  |  | Site 1 | 15
3 | Site 1 | 2012-06-06 00:00:00 | 4 |  |  | Site 2 | 14
4 | Site 4 | 2012-04-04 00:00:00 | 8 |  |  | Site 3 | 14
6 | Site 5 | 2012-06-05 00:00:00 | 3 |  |  | Site 4 | 14
9 | Site 1 | 2012-06-06 00:00:00 | 9 |  |  | Site 5 | 14
24 | Site 2 | 2012-03-02 00:00:00 | 45
54657 | Site 4 | 2012-06-04 00:00:00 | 9
5476 | Site 3 | 2012-06-05 00:00:00 | 56
2 | Site 5 | 2012-04-05 00:00:00 | 2
33 | Site 3 | 2012-06-06 00:00:00 | 98
67 | Site 2 | 2012-06-06 00:00:00 | 43
79 | Site 4 | 2012-05-06 00:00:00 | 23
444 | Site 5 | 2012-06-04 00:00:00 | 2
33 | Site 4 | 2012-06-06 00:00:00 | 6
77 | Site 5 | 2012-07-12 00:00:00 | 1
54 | Site 4 | 2012-06-05 00:00:00 | 1
23 | Site 5 | 2012-05-04 00:00:00 | 1
15 | Site 5 | 2012-06-06 00:00:00 | 6
790 | Site 3 | 2012-06-05 00:00:00 | 3
2332 | Site 2 | 2012-06-04 00:00:00 | 198
113 | Site 5 | 2012-06-06 00:00:00 | 1
Spreadsheet: 96541ee0-ba60-4e20-94b0-66892707ef19
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7550 | 7720 | Iskandar | Shakhov | RUS | 143 | 00:16:51 | 00:00:29 | 00:23:54 | 00:00:58 | 00:18:25 | 1 | 01:00:40
7550 | 46691 | Pertti | Tuomainen | FIN | 141 | 00:17:55 | 00:00:36 | 00:22:27 | 00:01:08 | 00:18:48 | 2 | [NAME]
7550 | 15682 | [NAME] | [NAME] | RUS | 142 | 00:17:52 | 00:00:46 | [NAME] | 00:01:20 | 00:17:40 | 3 | 01:02:47
7550 | 47074 | Matti | Makinen | FIN | 140 | 00:19:48 | 00:01:06 | 00:26:04 | 00:01:18 | 00:18:11 | 4 | [NAME]
7550 | 7910 | Antti | Mustonen | FIN | 0 | 00:19:13 | [NAME] | 00:29:30 | 00:02:37 | 00:20:01 | 5 | 01:12:15
Spreadsheet: 77553d1278000010-identify-row-values-based-on-unique-data-example
Sheet: Sheet1

List
ERROR1 | Test112 |  | ERROR1 | Test112 | Test4 | [NAME]
nice | Test2 |  | nice | Test2
bb | Test3 |  | bb | Test3
ERROR1 | Test4 |  | ID3 | Test2
ERROR1 | [NAME] |  |  | 0 | 0 | 0 | 0 | 0
ID3 | Test2 |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 0
Error | Line
ERROR 1 | 25 |  | ERROR 1 | 25 | #N/A
ERROR 2 | 56 |  | ERROR 2
ERROR 1 | 46 |  | ERROR 3
ERROR 3 | 33
ERROR 2 | 45
ERROR 1 | 67
Spreadsheet: 107698d1304821393-vlookup-function-help-intexcel
Sheet: Salespeople

State | 2006 | 2007 | 2009 | Av Emp | Total Sales | Sales/Emp
CT | 2 | 2 | 2 | 2
MA | 8 | 6 | 5 | 6.333333333333333
ME | 4 | 3 | 4 | 3.666666666666667
NH | 6 | 5 | 5 | 5.333333333333333
NJ | 3 | 3 | 3 | 3
NY | 9 | 8 | 6 | 7.666666666666667
PA | 4 | 5 | 4 | 4.333333333333333
RI | 2 | 3 | 2 | 2.333333333333333
VT | 5 | 6 | 5 | 5.333333333333333
Spreadsheet: 476212d1471686912-data-validation-issue-data-validation
Sheet: Sheet2

 |  |  |  | The Value in the cell F5 should be greater than the last cell in the series below ( F8:G12)
 | Sl No | Coupon no. | Series
 | 1 | 52582
 | 2 | 52622
 | 3 | 52662
 | 4 | 52702
 | 5
Spreadsheet: mary_fischer__25630__1581 - 2001
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1581
COMPANY NAME  : FIRSTPOINT CONNECTIVITY
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION: [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 2000 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | 0
Paid in Capital |  | 0910 |  | 0
Contribution Received from Parent |  | 0915 |  | 0
RE - Beg Bal |  | 0920 |  | 0
RE - Net Income |  | 0930 |  | 0 |  |  |  | 0
RE - Net Income (Fair Value Adjustment) |  | 0931 |  | 0
Dividends Decl - Preferred Stock |  | 0935 |  | 0
Dividends Decl - Common Stock |  | 0941 |  | 0
Invest in Subs Plug Account |  | 0942 |  | 0 |  |  |  | -1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO # |  | 0985
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
Current year earnings have not rolled yet.
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 04 May 20 - 09 May 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 04/05/2020 - 09/05/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Nathan | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | ✓ | AWAY | ✓ | ✓ | ✓ |  |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | ✓
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  |  | ❌
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  |  | ✓
Edge Protection [NAME] |  |  | 04/05/2020 - 09/05/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 04/05/2020 - 09/05/2020
Laminex |  |  | ❌ |  |  |  |  |  |  | Dameon | ✓
Wilson |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
[NAME] |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | ✓
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: 155971d1337119154-count-of-unique-stores-in-a-group-storecountsample-1-
Sheet: Sheet1

Store # | Group Name | Item #
100 | ABC | 1279
100 | ABC | 1145
100 | ABC | 1041
100 | ABC | 1901
100 | ABC | 1298
100 | ABC | 1174
101 | DEF | 1814
101 | DEF | 1999
101 | DEF | 1069
101 | DEF | 1897
101 | DEF | 1224
101 | DEF | 1731
101 | DEF | 1787
102 | GHI | 1007
102 | GHI | 1540
102 | GHI | 1853
102 | GHI | 1837
102 | GHI | 1273
102 | GHI | 1127
102 | GHI | 1212
102 | GHI | 1980
103 | JKL | 1746
103 | JKL | 1709
103 | JKL | 1817
103 | JKL | 1499
103 | JKL | 1511
103 | JKL | 1814
103 | JKL | 1226
103 | JKL | 1669
103 | JKL | 1927
Spreadsheet: 783848d1655202804-update-of-iferror-lookup-formula-by-adding-max-formula-test_formula
Sheet: Sheet1

Name | Date | Attendance | EXM 1 | EXM CR1 | Date | Attendance | EXM 2 | EXM CR2 | Date | Attendance | EXM 3 | EXM CR3 | Date | Attendance | EXM4 | EXM CR4 | Final result | NEW | not working
[NAME] | 2021-04-21 00:00:00 | Present | 57.5 | 60
Lukas | 2021-04-21 00:00:00 | Present | 55 | 62.5 | 2021-08-13 00:00:00 | Present | 60
Maria | 2021-04-21 00:00:00 | Present | 22.5 | 25 | 2021-08-13 00:00:00 | Present | 45 |  | 2021-12-23 00:00:00 | Excused | n/a |  | 2022-03-10 00:00:00 | Present | 55
[NAME] | 2021-04-21 00:00:00 | Present | 52.5 |  | 2021-08-13 00:00:00 | Present | 57.5 |  | 2022-06-10 00:00:00 | Excused | n/a |  | xx
[NAME] | 2021-04-21 00:00:00 | Present | 57.5 | 65 | 2021-08-13 00:00:00 | Present | 60
[NAME] | 2021-04-21 00:00:00 | Present | 90 | 92.5
Dwayne | 2021-04-21 00:00:00 | Present | 45 |  | 2021-08-13 00:00:00 | Present | 57.5 |  | 2021-12-23 00:00:00 | Present | 62.5
[NAME] | 2021-04-21 00:00:00 | Excused | n/a |  | 2021-08-13 00:00:00 | Present | 45 |  | 2021-12-23 00:00:00 | Excused | n/a |  | 2022-03-10 00:00:00 |  | pending
Rowena | 2021-11-18 00:00:00 | Present | 52.5 | 57.5 | 2021-12-22 00:00:00 | Present | 47.5 |  | 2022-02-10 00:00:00 | Present | 67.5
Malone | 2022-06-20 00:00:00 |  | pending
Ivana
Spreadsheet: 875525d1722102919-using-dropdowns-to-indicate-task-completion-status-with-color-coding-no-merged-or-wrapped
Sheet: Hypertrofi - Meso 1

Random Task 1 | 1 | 1 | 1 | 1
Random Task 2 | 1 |  |  | 2
Random Task 3 | 1 |  |  | 3
Random Task 4 | 1 |  |  | 4
Random Task 5 | 1 |  |  | 5 |  |  |  |  |  |  | 1
Random Task 2 | 2 | 1 | 1 | 1 |  |  |  |  |  |  | 2
Random Task 3 | 2 | 2 | 2 | 2 |  |  |  |  |  |  | 3
Random Task 4 | 2 |  |  | 3 |  |  |  |  |  |  | 4
Random Task 5 | 2 |  |  | 4 |  |  |  |  |  |  | 5
Random Task 6 | 2 |  |  | 5
Random Task 3 | 3 | 1 | 1 | 1
Random Task 4 | 3 | 2 | 2 | 2
Random Task 5 | 3 | 2 |  | 3
Random Task 6 | 3 |  |  | 4
Random Task 7 | 3 |  |  | 5
Spreadsheet: 142268d1329760076-drag-down-mismatch-pull-wrong-cell-need-in-my-cell-test_fill
Sheet: data

 |  |  |  |  |  |  | Difference |  | Store |  |  | Comments
 |  |  |  |  |  |  | 10 |  | 200 |  |  | 10
 |  |  |  |  |  |  | 20 |  | 0 |  |  | 20
 |  |  |  |  |  |  | 30 |  | 100 |  |  | 20
 |  |  |  |  |  |  | 40 |  | 40 |  |  |  | pull data from H2 and J2 instead of H5 and J5
 |  |  |  |  |  |  | 50 |  | 50 |  |  |  | pull data from H2 and J2 instead of H6 and J6
 |  |  |  |  |  |  | 60 |  | 2 |  |  |  | pull data from H2 and J2 instead of H7 and J7
 |  |  |  |  |  |  | 70 |  | 70 |  |  |  | pull data from H2 and J2 instead of H8 and J8
 |  |  |  |  |  |  | 80 |  | 80 |  |  | 100
 |  |  |  |  |  |  | 90 |  | 90 |  |  | 100
 |  |  |  |  |  |  | 100 |  | 100 |  |  |  | pull data from H2 and J2 instead of H11 and J11
Spreadsheet: 2b3d7aec-ab93-4ca3-a66e-b9b35d74ee05
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259208 | 40700 | Javier | Merida | ESP |  | 00:34:12 | 00:05:45 | 03:50:38 | 00:02:12 | 03:28:14 | 1 | 08:01:01