tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jason_wolfe__13511__actualloadapril&may
Sheet: Sheet1

 | @CG
 | MMBTU
 | TOTAL
1998-04-01 00:00:00 | 8713.302
1998-04-02 00:00:00 | 12426.57
1998-04-03 00:00:00 | 13817.778
1998-04-04 00:00:00 | 13646.412
1998-04-05 00:00:00 | 12352.548
1998-04-06 00:00:00 | 13812.708
1998-04-07 00:00:00 | 13700.154
1998-04-08 00:00:00 | 13827.918
1998-04-09 00:00:00 | 12933.57
1998-04-10 00:00:00 | 12177.126
1998-04-11 00:00:00 | 11973.312
1998-04-12 00:00:00 | 12963.99
1998-04-13 00:00:00 | 13093.782
1998-04-14 00:00:00 | 12419.472
1998-04-15 00:00:00 | 11540.334
1998-04-16 00:00:00 | 10941.06
1998-04-17 00:00:00 | 8252.946
1998-04-18 00:00:00 | 9414.99
1998-04-19 00:00:00 | 11375.052
1998-04-20 00:00:00 | 14574.222
1998-04-21 00:00:00 | 12350.52
1998-04-22 00:00:00 | 10069.02
1998-04-23 00:00:00 | 10142.028
1998-04-24 00:00:00 | 7615.14
1998-04-25 00:00:00 | 6907.368
1998-04-26 00:00:00 | 8023.782
1998-04-27 00:00:00 | 8873.514
1998-04-28 00:00:00 | 8379.696
1998-04-29 00:00:00 | 8794.422
1998-04-30 00:00:00 | 7947.732
1998-05-01 00:00:00 | 7388.184999999999
1998-05-02 00:00:00 | 7498.82
1998-05-03 00:00:00 | 6655.355
1998-05-04 00:00:00 | 6724.374999999999
1998-05-05 00:00:00 | 6014.89
1998-05-06 00:00:00 | 5916.434999999999
1998-05-07 00:00:00 | 5642.384999999999
1998-05-08 00:00:00 | 5405.89
1998-05-09 00:00:00 | 5909.33
1998-05-10 00:00:00 | 6142.78
1998-05-11 00:00:00 | 6143.794999999999
1998-05-12 00:00:00 | 6168.155
1998-05-13 00:00:00 | 6711.18
1998-05-14 00:00:00 | 7515.06
1998-05-15 00:00:00 | 6445.25
1998-05-16 00:00:00 | 6319.39
1998-05-17 00:00:00 | 6561.974999999999
1998-05-18 00:00:00 | 6305.18
1998-05-19 00:00:00 | 5655.58
1998-05-20 00:00:00 | 5348.035
1998-05-21 00:00:00 | 5778.395
1998-05-22 00:00:00 | 6011.844999999999
1998-05-23 00:00:00 | 6229.054999999999
1998-05-24 00:00:00 | 6344.764999999999
1998-05-25 00:00:00 | 6753.81
1998-05-26 00:00:00 | 6421.905
1998-05-27 00:00:00 | 6746.704999999999
1998-05-28 00:00:00 | 7582.05
1998-05-29 00:00:00 | 6840.084999999999
1998-05-30 00:00:00 | 5393.71
1998-05-31 00:00:00 | 4786.74
Spreadsheet: 46859d1245784588-rows-to-column-for-specific-data-sample-spreadsheet
Sheet: Worksheet A

Dealer # | Dealer Name | Zip Code
A30352 | [NAME] | 48152
A30352 | [NAME] | 48152
B02194 | [NAME]'s Refrig Htg & A/C Inc | 48044
B02194 | [NAME]'s Refrig Htg & A/C Inc | 48044
B02194 | [NAME]'s Refrig Htg & A/C Inc | 42324
B06674 | Hopkins Air Conditioning | 50266
B06674 | Hopkins Air Conditioning | 53135
B07618 | Aiello Home Services | 06096,06095,06082,06088,06035,06033,06117,06119
B07618 | Aiello Home Services | 06096,06095,06082,06088,06035,06033,06117,06119
B07618 | Aiello Home Services | 06094,50225
B07838 | Parrish Services | 20147,20165
B10342 | [NAME] | 19958,19971,19968,19969,19930,19970
B12086 | Patriot Air Comfort Systems LLC | 43221,43054,43071,43147,43209
Dealer # | Dealer Name | Zip Code 1 | Zip Code 2 | Zip Code 3
A30352 | [NAME] | 48152 | 48152
B02194 | [NAME]'s Refrig Htg & A/C Inc | 48044 | 48044
B02194 | [NAME]'s Refrig Htg & A/C Inc | 42324
B06674 | Hopkins Air Conditioning | 50266 | 53135
B07618 | Aiello Home Services | 06096,06095,06082,06088,06035,06033,06117,06119 | 06096,06095,06082,06088,06035,06033,06117,06119
B07618 | Aiello Home Services | 06094,50225
B07838 | Parrish Services | 20147,20165
B10342 | [NAME] | 19958,19971,19968,19969,19930,19970
B12086 | Patriot Air Comfort Systems LLC | 43221,43054,43071,43147,43209
Spreadsheet: 850621d1701017194-looking-for-non-array-formula-to-extract-values-if-condition-is-met-extract_withholding_sample-file
Sheet: Withholding

(a) SINGLE STANDARD person or Married Filing Separately |  |  |  |  |  |  |  |  |  |  | Fed Taxable |  | 983.96
W-4 Year | Checked/Not Checcked? | Old/New? | Filing Type | At least | But less than | The tentative amount to withhold is: | Plus this percentage | of the amount that the Adjusted Annual Wage or Payment exceed | Filing Type | Filing Type
W-4 (before 2020) | Not Checked | Old W-4 | Single | 0 | 5250 | 0 | 0 |  | Single | Married Filing Separately
W-4 (before 2020) | Not Checked | Old W-4 | Single | 5250 | 16250 |  | 0.1 |  | Single | Married Filing Separately
W-4 (before 2020) | Not Checked | Old W-4 | Single | 16250 | 49975 |  | 0.12 |  | Single | Married Filing Separately
W-4 (before 2020) | Not Checked | Old W-4 | Single | 49975 | 100625 |  | 0.22 |  | Single | Married Filing Separately
W-4 (before 2020) | Not Checked | Old W-4 | Single | 100625 | 187350 |  | 0.24 |  | Single | Married Filing Separately
W-4 (before 2020) | Not Checked | Old W-4 | Single | 187350 | 236500 |  | 0.32 |  | Single | Married Filing Separately
W-4 (before 2020) | Not Checked | Old W-4 | Single | 236500 | 583375 |  | 0.35 |  | Single | Married Filing Separately
W-4 (before 2020) | Not Checked | Old W-4 | Single | 583375 | 0 |  | 0.37 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 0 | 6925 | 0 | 0 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 6925 | 12425 |  | 0.1 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 12425 | 29288 |  | 0.12 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 29288 | 54613 |  | 0.22 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 54613 | 97975 |  | 0.24 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 97975 | 122550 |  | 0.32 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 122550 | 295988 |  | 0.35 |  | Single | Married Filing Separately
W-4 (2020 or later) | Checked | New W-4 | Single | 295988 | 0 |  | 0.37 |  | Single | Married Filing Separately
Spreadsheet: 138366d1327625690-excel-2007-hypelink-hell-copy-of-tlc-client-progress-3-
Sheet: Martin Oppenlander

Client
Student
 | Date Completed | Comments
Initial Contact
Details put on database
Evaluation
Evaluation Report Received
Follow Up with Parent
Course Overview Made
Confirmed Teacher
Teacher Availability Updated
Sent out T&Cs/Welcome Pack
Added Lessons to Database
Send info to JF
Follow Up 1st class
How often do they want follow up?
20 classes
40 classes
Band Scores
Initial
20 classes
40 classes
Spreadsheet: 853921d1703866141-chatgpt-says-this-cant-be-done-without-vba-track-menstruation
Sheet: Calendary

 |  |  |  |  |  |  |  |  | You could use a formula like that for better visualization of the periods.
Spreadsheet: kate_symes__18708__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
 | 2001-02-04 00:00:00 |  | 150 | 0 | 146.67 | 1200 | 94.46 | 2705 | 81.4 | 2734
 | 2001-02-03 00:00:00 |  | 165 | 0 | 152.1 | 2000 | 127.82 | 6039 | 83.63 | 2119
 | 2001-02-02 00:00:00 |  | 160 | 320 | 148.88 | 1600 | 145.26 | 2069 | 111.08 | 2227
 | 2001-02-01 00:00:00 |  | 231.82 | 176 | 161.58 | 696 | 171.56 | 2512 | 111.53 | 1611
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32 | 196.22 | 2670 | 133.68 | 1348
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
 | 2001-01-29 00:00:00 |  | 232.86 | 224 | 197.1 | 1000 | 188.91 | 2740 | 130.63 | 1506
 | 2001-01-28 00:00:00 |  | 200 | 320 | 175 | 0 | 178.38 | 3068 | 130.84 | 1999
 | 2001-01-27 00:00:00 |  | 232.14 | 560 | 159 | 1000 | 196.47 | 1231 | 125.85 | 2421
 | 2001-01-26 00:00:00 |  | 241.67 | 720 | 159 | 1000 | 198.58 | 1670 | 142.36 | 652
 | 2001-01-25 00:00:00 |  | 239.29 | 560 | 151.67 | 600 | 144.13 | 2493 | 118.25 | 883
 | 2001-01-24 00:00:00 |  | 175 | 800 | 141.17 | 1200 | 131.25 | 2165 | 106.42 | 399
Spreadsheet: 697670d1601471717-how-to-dynamically-update-the-range-for-an-excel-chart-dynamic-range-update-for-excel-chart-redjohn89-
Sheet: Pivot2

Product | Country | Sum of Quantity
Chair | US | 4
Jar | FR | 5
Pen | US | 8
Sofa | JP | 5
Table | FR | 8
TV | JP | 1
Grand Total |  | 31
Spreadsheet: 27e6c325-d795-493e-ba6c-4e1f61becc93
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3381 | 18704 | [NAME] | Myllymaki | CAN | 0 |  |  |  |  |  | 1
3381 | 18703 | Kurt | Blattma | SUI | 0 |  |  |  |  |  | 2
3381 | 10171 | [NAME] | Bright | NZL | 0 |  |  |  |  |  | 3
3381 | 5328 | Stephane | Poulat | FRA | 0 |  |  |  |  |  | 4
3381 | 15201 | [NAME] | Harper | AUS | 0 |  |  |  |  |  | 5
3381 | 5691 | Ralf | [NAME] | GER | 0 |  |  |  |  |  | 6
3381 | 15206 | [NAME] | Heldoorn | NED | 0 |  |  |  |  |  | 7
3381 | 14920 | [NAME] | Macmartin | CAN | 0 |  |  |  |  |  | 8
3381 | 5607 | [NAME] | Bignet | FRA | 0 |  |  |  |  |  | 9
3381 | 15288 | Mathew | Belfield | GBR | 0 |  |  |  |  |  | 10
Spreadsheet: 113608d1309450905-cannot-solve-vlookup-mid-function-problem-autodecode
Sheet: Flash Decode

Part # | [NAME]
CodeGroup | Reference | Code | Description |  | From Your VLOOKUP Description |  | Your formulae "Fixed"
1
2
3
4,5
6
7
8
9
10
11 |  |  |  |  | - |  | -
12
13
14
15
16
17,18
Spreadsheet: 60002d1260528481-not-able-to-sort-dates-date-issue
Sheet: Date issue

 | Next-Schedu
 | Nov 20 2010 |  | 2010-11-20 00:00:00
 | Aug 2 2010
 | [NAME]
 | May 31 2010
 | Feb 26 2010
 | Feb 23 2010
 | Feb 23 2010
 | Feb 23 2010
 | Feb 9 2010
 | Jan 10 2010
 | Oct 5 2010
 | Oct 5 2010
 | Sep 23 2010
 | Sep 5 2010
 | Aug 8 2010
 | Oct 17 2010
 | Oct 7 2010
 | Jan 13 2010
 | Feb 17 2010
 | Nov 20 2010
 | Jan 1 2010
 | Aug 21 2010
 | Apr 12 2010
 | Apr 11 2010
 | Jun 21 2010
 | Jun 13 2010
 | Sep 14 2010
 | Jun 26 2010
 | Mar 26 2010
 | Feb 12 2010
 | Feb 26 2010
 | Oct 23 2010
 | Aug 23 2010
 | Nov 4 2010
 | Dec 10 2010
 | Oct 19 2010
 | Sep 2 2010
 | Aug 7 2010
 | Oct 25 2010
Spreadsheet: 162634d1340018369-excel-formulas-seem-to-stop-working-at-a-certain-range-camp-sign-up-spreadsheet-test
Sheet: Cooking Week

 | Name | Age | Emergency Contact | Phone Number
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
Spreadsheet: 729264d1618992098-extracting-and-arranging-data-salary
Sheet: Expected Result

 |  | JVN0711 |  |  | JVN0711
 |  | Salary | PF | GT | Salary | PF | GT
 | Suman Magar | 3821.45 | 518.21 | 215.83
 | [NAME] | 3620.32 | 490.94 | 204.47
 | [NAME] | 2815.81 | 381.84 | 159.04
 | [NAME].[NAME] | 1206.77 | 136.65 | 68.16
 | Amit Choudhary | 0 | 0 | 0 | 12067.74 | 1636.45 | 681.58
Spreadsheet: 881966d1730211581-extracting-data-from-machine-generated-participants-list-extracting-data-from-machine-generated-participants-list
Sheet: Blad1

Participants |  |  |  | Name | Age | Camp | Bed | [NAME] | Birthday
Name = "[NAME]" |  |  |  | [NAME] | 36 | 64 | 1a |  | April 4
Age = "36" |  |  |  | [NAME] | 35
Birthday = "April 4" |  |  |  | [NAME] | 26
Camp = "64" |  |  |  | [NAME] | 35
Bed = "1a" |  |  |  | Eagle | 32
Name = "Alice"
Age = "35"
Camp = "Frisk"
Bed = "1g"
Name = "Brad"
Age = "26"
Linnen = "No"
Camp = "14a"
Bed = "1b"
Name = "Mary"
Birthday  = "6th june"
Camp = "Eagle"
Age = "35"
Bed = "1v"
Name = "Eagle"
Age = "32"
Camp = "62"
Bed = "1c"
Spreadsheet: cd5d8280-60cf-44ec-a946-bec48023e990
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Financial Report
 |  | All Manufacturing: U.S. Total
 |  | Not Seasonally Adjusted Net Sales, Receipts, and Operating Revenues [Millions of Dollars]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: March 8, 2014 (3:05 pm)
Period | Value
Q1-2000
Q2-2000
Q3-2000
Q4-2000 | 1128790
Q1-2001 | 1082233
Q2-2001 | 1116597
Q3-2001 | 1062443
Q4-2001 | 1033734
Q1-2002 | 994073
Q2-2002 | 1071574
Q3-2002 | 1068667
Q4-2002 | 1082128
Q1-2003 | 1072017
Q2-2003 | 1096910
Q3-2003 | 1109436
Q4-2003 | 1118800
Q1-2004 | 1145872
Q2-2004 | 1248717
Q3-2004 | 1250976
Q4-2004 | 1288495
Q1-2005 | 1258442
Q2-2005 | 1352179
Q3-2005 | 1384246
Q4-2005 | 1416600
Q1-2006 | 1397414
Q2-2006 | 1485624
Q3-2006 | 1467143
Q4-2006 | 1432485
Q1-2007 | 1405836
Q2-2007 | 1526484
Q3-2007 | 1539399
Q4-2007 | 1588312
Q1-2008 | 1566418
Q2-2008 | 1724172
Q3-2008 | 1682270
Q4-2008 | 1401261
Q1-2009 | 1196693
Q2-2009 | 1253821
Q3-2009 | 1305867
Q4-2009 | 1353446
Q1-2010 | 1349210
Q2-2010 | 1461717
Q3-2010 | 1463507
Q4-2010 | 1481530
Q1-2011 | 1532484
Q2-2011 | 1657405
Q3-2011 | 1650561
Q4-2011 | 1645072
Q1-2012 | 1648177
Q2-2012 | 1689523
Q3-2012 | 1656755
Q4-2012 | 1673222
Q1-2013 | 1626653
Q2-2013 | 1705701
Q3-2013 | 1707960
Q4-2013
Spreadsheet: 94195d1294075989-excel-2007-conditional-formatting-for-dates-dealer-support-sample
Sheet: Sheet1

 |  |  |  |  |  | Closed Date | Contract Start | Contract Stop | FROM CSR DATE | TO CORP DATE | REPLY DATE
 |  |  |  |  |  | 2010-04-30 00:00:00 | 2010-05-01 00:00:00 | 2015-03-31 00:00:00 |  | 2010-10-16 00:00:00 | 2010-10-22 00:00:00
 |  |  |  |  |  | 2010-05-01 00:00:00 | 2010-07-01 00:00:00 | 2014-06-30 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00
 |  |  |  |  |  | 2010-05-02 00:00:00 | 2010-07-01 00:00:00 | 2014-06-30 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00
 |  |  |  |  |  | 2010-05-03 00:00:00 | 2010-07-01 00:00:00 | 2014-06-30 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00
 |  |  |  |  |  | 2010-05-04 00:00:00 | 2010-07-01 00:00:00 | 2014-06-30 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00
Spreadsheet: 0d71e578-1722-406e-837b-72b411de5507
Sheet: 50DIV.

ISA SENIOR WINTER NATIONALS
POLK COUNTY, FLORIDA
[NAME]
 | MEN'S 50 MAJOR & 50AAA DIVISIONS
 | ALL GAMES PLAYED AT DIAMOND PLEX
 |  |  |  |  |  | WON |  | LOSS
1.  BLAST,M
2.  FLORIDA AUTOMATEDSHADE, M
3.  MIAMI POWER, M
4.  STEVE LEVIN 50, M
5.  FREEDOM RANCH, AAA
6.  CROSS CUT, AAA
TIME |  | RUNS |  | TEAM # |  | RUNS |  | DIA. #
9AM |  |  |  | 5 V 1 |  |  |  | B
9AM |  |  |  | 6 V 3 |  |  |  | C
10:30AM |  |  |  | 5 V 4 |  |  |  | B
10:30AM |  |  |  | 6 V 2 |  |  |  | C
12:30PM |  |  |  | 4 V 2 |  |  |  | B
12:30PM |  |  |  | 3 V 1 |  |  |  | C
2PM |  |  |  | 5 V 2 |  |  |  | B
2PM |  |  |  | 6 V 1 |  |  |  | C
2PM |  |  |  | 4 V 3 |  |  |  | D
NOTE:  TEAMS 4 & 5 GET 5 RUNS OR 11 DEFENSIVE PLAYERS WHEN PLAYING TEAMS 1 THRU 4
[NAME]: | ALL TEAMS WILL PLAY 3 SEED GAMES.  THEN TEAMS 5 & 6 WILL PLAY THE BEST 2 OUT OF 3
 | TEAMS 1 thru 4 WILL BREAK OFF INTO A DOUBLE ELIMINATION BRACKET
HOME RUN RULE - MAJOR IS 6 THEN WALKS, AAA IS 3 PER GAME, THEN OUTS.   If AAA IS PLAYING
 |  | A MAJOR TEAM THEN YOU USE THE AAA HOME RUN RULE.
RUN RULE- 5 RUNS PER 1/2 INNING + OPEN INNING
TIME LIMITS - SEED GAMES 65 MIN. + OPEN INNING - BRACKET PLAY 70MIN.+ OPEN
 |  | CHAMPIONSHIP GAME IS 7 INNINGS
[NAME] FLIP
ROSTER IS SUBJECT TO APPROVAL OF SSUSA
YOU MUST WIN YOUR DIVISION TO RECEIVE THE SSUSA TOC BERTH
Spreadsheet: 862565d1710255541-need-help-totaling-based-on-selections-mix-id-calculator-bdh-2
Sheet: Sheet1

This section is where the results are displayed. |  |  |  |  |  |  |  |  |  | This section is where I manipulate the lists and price.  Can be done on another tab.
Base Price | Mix ID | Add On |  |  |  | Distance | Total |  |  | Mix ID | Price |  | Add On | Price |  | Distance | Price
 |  | Air | HRWR | 3/8 Agg | [NAME]
121 | COM501510 |  |  |  |  | 11-20 |  |  |  | COM301510 | base |  | Air | 3 |  | 1-10 | 0 |  | True
 |  |  |  |  |  |  |  |  |  | COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5 |  | True
 |  |  |  |  |  |  |  |  |  | COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10 |  | False
 |  |  |  |  |  |  |  |  |  | COM451510 | 15 |  | [NAME] | 13 |  | 31-40 | 20 |  | False
 |  |  |  |  |  |  |  |  |  | COM501510 | 20 |  | 1%Retard | 0
 |  |  |  |  |  |  |  |  |  | COM601510 | 30 |  | 2%Retard | 1
 |  |  |  |  |  |  |  |  |  | COM701510 | 40 |  | 3%Retard | 2
 |  |  |  |  |  |  |  |  |  | COM801510 | 50 |  | Fiber | 7
 |  |  |  |  |  |  |  |  |  | 500S | 7 |  | SRA | 75
 |  |  |  |  |  |  |  |  |  | 550S | 12 |  | SS | 7
 |  |  |  |  |  |  |  |  |  | 600S | 17
 |  |  |  |  |  |  |  |  |  | 650S | 22
 |  |  |  |  |  |  |  |  |  | 700S | 27
 |  |  |  |  |  |  |  |  |  | 800S | 32
Spreadsheet: 0a0fbe0a-6c9f-47e7-9fa4-ebc6d91b3cf0
Sheet: Salaries

SALARIES
Provide information for all CACFP-related employees.  If you have employees that are not paid based on a monthly salary or hourly rate, please attach additional information (i.e., dollar rate per home).
For all employees, if salaries are increased since last year provide the following for each applicable employee: Date increase is effective; percentage and nature of increase.
Cost of living increases in pay must be based on current, generally acepted statistical data. Provide explanation in cost allocation plan.
 |  |  |  | For Salaried Employees | For Hourly Employees |  | Nature of Increase
Employee Name: First and Last | Position Title | If position is hourly place an "X" in this box | Daily work hours (include beginning & end times) | Gross Monthly Rate (before deductions) | Gross Hourly rate (before deductions) | Annual Percentage of Increase | (Cost-of-living or Merit) | Total Work Hours per month | Total Work Hours for CACFP per month | Percent of Total Work Hours for CACFP | Total Required Employer Taxes per month* | Total Employer Taxes Paid Per month by CACFP. | Total Annual Cost to CACFP ** *
 |  |  |  | 0 | 0 | 0 | COL | 1 | 0 |  |  | 0
 |  |  |  | 0 | 0 | 0 | Merit | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  | 0 | 0 | 0 |  | 1 | 0
 |  |  |  |  |  |  |  | Total  CACFP Salaries
*  [NAME] Compensation, Unemployment Insurance, Social Security Tax, and any other required tax.
Spreadsheet: 0b3d82c7-cf6a-44e8-8766-32256698378a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7905 | 8155 | [NAME] | Isaacs | USA | 4833 | 01:10:44 | 00:16:43 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 876221d1722903300-need-formula-on-inventory-fifo
Sheet: Sheet1

 | Inventory with FIFO |  |  |  |  |  |  |  |  |  | Inventory with FIFO
 | Purchased |  |  | Sold |  |  | Balance |  |  |  | Purchased |  |  | Sold |  |  | Balance
 | Unit | Price | Total | Unit | Price | Total | Unit | Price | Total |  | Unit | Price | Total | Unit | Price | Total | Unit | Price | Total
 | 90 | 12 |  |  |  |  | 90 | 12 |  |  | 90 | 12
 | 82 | 13 |  |  |  |  | 82 | 13 |  |  | 82 | 13
 |  |  |  | 15 | 12 |  |  | 12 |  |  |  |  |  | 15 | 12
 |  |  |  |  |  |  | 82 | 13
 | Can anyone help me how to create a formula on Balance column,
 | that make purchase, sold data appear automatically on balance?
 | I'm using FIFO Method.
 | in FIFO, the first product to sold, is the product that come early.
Spreadsheet: 752229d1634657415-formula-simplification-help-sum-specific-rows-based-on-cell-tracking
Sheet: x01

Project | Rate
Project 1 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 5
Project 2 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 15
Project 3 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 20
Total Standard Regular |  |  |  |  | Week Standard Regular |  |  |  |  |  |  | Week Standard Regular |  |  |  |  |  |  | Week Standard Regular |  |  |  |  |  |  | Week Standard Regular
Total Standard Overtime |  |  |  |  | Week Standard Overtime |  |  |  |  |  |  | Week Standard Overtime |  |  |  |  |  |  | Week Standard Overtime |  |  |  |  |  |  | Week Standard Overtime
Total Special Regular |  |  |  |  | Week Special Regular |  |  |  |  |  |  | Week Special Regular |  |  |  |  |  |  | Week Special Regular |  |  |  |  |  |  | Week Special Regular
Total Special Overtime |  |  |  |  | Week Special Overtime |  |  |  |  |  |  | Week Special Overtime |  |  |  |  |  |  | Week Special Overtime |  |  |  |  |  |  | Week Special Overtime
Spreadsheet: 745909d1630358646-help-with-sumproduct-formula-that-contains-text-and-numbers-over-multiple-tables-t3-bvj-
Sheet: STAFF ROOMS

HOUSE | TYPE | ROOM | PRICE |  |  |  |  | House | Type | Basement | Ground | 3 | 4 | 5
Compston | Single | Basement |  |  |  |  |  | Compston | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | Kirkwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | Brinwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 80 | 90 | 91 | 92 | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compston | Kirkwood | Brinwood
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basement | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
Spreadsheet: 124271d1318285447-fail-safe-fail-safe-example
Sheet: Sheet1

 | ANIMALS ON FARM 102 |  |  |  |  |  | LIST OF ANIMALS
 | PIG |  | HORSE |  |  |  | PIG
 | COW |  | CAR |  |  |  | CAT
 | CHICKEN |  | RABBIT |  |  |  | COW
 | GOAT |  | CAT |  |  |  | DOG
 |  |  |  |  |  |  | CHICKEN
 |  |  |  |  |  |  | GOAT
 |  |  |  |  |  |  | RABBIT
 |  |  |  |  |  |  | TURKEY
 |  |  |  |  |  |  | FISH
 |  |  |  |  |  |  | LLAMA
 |  |  |  |  |  |  | PENGUIN
 |  |  |  |  |  |  | LION
 |  |  |  |  |  |  | TIGER
 |  |  |  |  |  |  | BEAR
 |  |  |  |  |  |  | ELK