tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139188d1328118760-sum-values-from-one-collumn-according-to-values-from-another-one-excel-problem-sum-modified-by-tigeravatar-
Sheet: Sheet1

Day | Stake | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Sum all stakes from last "day 1" until yesterday
1 | 2
1 | 2
1 | 2
2 | 3
3 | 5
1 | 2
2 | 3
3 | 5
4 | 9
5 | 14
6 | 18
1 | 2
2 | 3
3 | 5
Columns A and B will be manually filled in. I need Column R to calculate sum of all stakes from last day one untill yesterday (that means value from today are not included). If value in Column A=1, sum of all previous days is 0.
This calculation works properly but it is too much complicated to fill it with more rows.. I need it untill 200-300 rows to be automatically calculated.
I hope it is possible to solve this formula in one column formula. (Maybe with "offset" function?) . The way I've used above is too complicated.
Any help will be appreciated. Thank you very much in advance.
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: Master

 | Houston
 |  | Gas Trading |  | (including NGLs) |  |  |  |  |  | 43
 |  | Gas Origination (includes Mexico) |  |  |  |  |  |  |  | 34
 |  | Admins |  |  |  |  |  |  |  | 12
 |  | Power Trading |  |  |  |  |  |  |  | 43
 |  | Power Origination |  |  |  |  |  |  |  | 14
 |  | Development Systems |  |  |  |  |  |  |  | 3
 |  | Admins |  |  |  |  |  |  |  | 4
 | Portland
 |  | Power Trading |  |  |  |  |  |  |  | 23
 |  | Power Origination |  |  |  |  |  |  |  | 13
 |  | Admins |  |  |  |  |  |  |  | 4
 | Canada
 |  | Trading |  |  |  |  |  |  |  | 11
 |  | Origination |  |  |  |  |  |  |  | 15
 |  | Admins |  |  |  |  |  |  |  | 5
 | Fundamentals
 |  | Houston (includes Competitor Analysis = 3) |  |  |  |  |  |  |  | 23
 |  | Portland |  |  |  |  |  |  |  | 6
 | Structuring
 |  | Houston |  |  |  |  |  |  |  | 3
 |  | Portland |  |  |  |  |  |  |  | 2
 | Weather |  |  |  |  |  |  |  |  | 5
 | Research |  |  |  |  |  |  |  |  | 2
 | Market Risk |  |  |  |  |  |  |  |  | 3
 | Credit |  |  |  |  |  |  |  |  | 15
 | Regulatory Affairs |  |  |  |  |  |  |  |  | 9
 | Energy Operations
 |  | Gas Logistics |  |  |  |  |  |  |  | 33
 |  | Gas Book Running |  |  |  |  |  |  |  | 41
 |  | Gas Settlements |  |  |  |  |  |  |  | 21
 |  | Gas Volume Management |  |  |  |  |  |  |  | 7
 |  | Documentation |  |  |  |  |  |  |  | 30
 |  | Power Logistics |  |  |  |  |  |  |  | 13
 |  | Power Book Running |  |  |  |  |  |  |  | 11
 |  | Power Settlements & Confirms |  |  |  |  |  |  |  | 9
 |  | Power Volume Management |  |  |  |  |  |  |  | 8
 |  | Financial Settlements |  |  |  |  |  |  |  | 9
 |  | Management |  |  |  |  |  |  |  | 2
 | Technology
 |  | Infrastructure |  |  |  |  |  |  |  | 60
 |  | Development |  |  |  |  |  |  |  | 38
 |  | Software Ops & Maintenance |  |  |  |  |  |  |  | 77
 |  | Fundamentals |  |  |  |  |  |  |  | 8
 |  | DBA/livelink |  |  |  |  |  |  |  | 12
 |  | Management & Admins |  |  |  |  |  |  |  | 5
 | OOC |  |  |  |  |  |  |  |  | 4
 | EnronOnline |  |  |  |  |  |  |  |  | 30
 | HR |  |  |  |  |  |  |  |  | 12
 | Legal |  |  |  |  |  |  |  |  | 20
 | Accounting |  |  |  |  |  |  |  |  | 44
 | Transaction Support |  |  |  |  |  |  |  |  | 2
 | Cash Operations |  |  |  |  |  |  |  |  | 6
 | SAP |  |  |  |  |  |  |  |  | -
 | [NAME] (including Legal but not HR) |  |  |  |  |  |  |  |  | 33
Spreadsheet: 767791d1644635513-job-estimating-linest-function-thisandthat-
Sheet: Sheet1

Job | Small items (X1) | Large items (X2) | Hours to complete (Y) |  | Large items (M2) | Small items (M1) | Intercept |  | Check
Job 1 | 0 | 50 | 112 |  |  | -7.443298969072161 | -661.19587628866
Job 2 | 117 | 123 | 370
Job 3 | 492 | 352 | 1120
Spreadsheet: 113829d1309712243-excel-2007-timesheet-wage-test
Sheet: Sheet1

Job | Code | Pay | Code
Manger | 1 | 9 | 1
[NAME] | 2 | 8 | 2
Server | 3 | 4 | 3
Date | Sunday | Monday | Tuesday | Wednesday | Thrusday | Friday | Saturday
 | 2011-06-26 00:00:00
[NAME]: | 0 | 0 | 4.01 | 0 | 7.58 |  | 0 |  | Total Hours:
Pay |  |  |  |  |  |  |  |  | Gross Pay:
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesAug

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100806 | 2010-08-12 00:00:00 | Customer1 | Product11 | 10000 | 0.9999 | 9999 | 10945.81280788177
 | 100807 | 2010-08-14 00:00:00 | Customer2 | Product22 | 20000 | 0.55555 | 11111 | 12163.10892172961
 | 100808 | 2010-08-16 00:00:00 | Customer3 | Product33 | 30000 | 0.4074333333333333 | 12223 | 13380.40503557745
 | 100809 | 2010-08-18 00:00:00 | Customer4 | Product44 | 40000 | 0.333375 | 13335 | 14597.70114942529
 | 100810 | 2010-08-20 00:00:00 | Customer5 | Product55 | 50000 | 0.28894 | 14447 | 15814.99726327313
 | 100811 | 2010-08-22 00:00:00 | Customer6 | Product66 | 60000 | 0.2593166666666666 | 15559 | 17032.29337712096
 | 100812 | 2010-08-24 00:00:00 | Customer7 | Product77 | 70000 | 0.2381571428571428 | 16671 | 18249.5894909688
 | 100813 | 2010-08-26 00:00:00 | Customer8 | Product88 | 80000 | 0.2222875 | 17783 | 19466.88560481664
 | 100814 | 2010-08-28 00:00:00 | Customer9 | [NAME] | 90000 | 0.2099444444444444 | 18895 | 20684.18171866448
DOMESTIC
Spreadsheet: 80204d1280403565-return-first-occurrence-return-first-occurrence
Sheet: Sheet1

ID |  |  | Type1_ID | [NAME] | Unit |  |  | Result:
1 |  |  | 1 | A | 1 |  |  | ID | Type1_ID | [NAME] | Unit
2 |  |  | 1 | B | 2 |  |  | 1 | 1 | A | 1
3 |  |  | 1 | A | 4 |  |  | 1 | 1 | B | 2
4 |  |  | 1 | A | 5 |  |  | 1 | 1 | C | 4
5 |  |  | 1 | B | 3 |  |  | 2 | 2 | A | 1
6 |  |  | 1 | C | 4 |  |  | 2 | 2 | B | 2
7 |  |  | 1 | C | 5 |  |  | 3 | 3 | A | 5
8 |  |  | 2 | A | 1 |  |  | 3 | 3 | B | 1
9 |  |  | 2 | B | 2 |  |  | 3 | 3 | C | 2
10 |  |  | 2 | A | 4 |  |  | 4 | 4 | A | 3
 |  |  | 3 | A | 5 |  |  | 4 | 4 | B | 4
 |  |  | 3 | B | 3 |  |  | 4 | 4 | C | 5
 |  |  | 3 | C | 4 |  |  | 5 | 5 | A | 5
 |  |  | 3 | C | 5 |  |  | 5 | 5 | B | 2
 |  |  | 3 | B | 1 |  |  | 5 | 5 | C | 1
 |  |  | 3 | C | 2
 |  |  | 3 | C | 4
 |  |  | 3 | A | 5
 |  |  | 4 | A | 3
 |  |  | 4 | B | 4
 |  |  | 4 | C | 5
 |  |  | 5 | C | 1
 |  |  | 5 | B | 2
 |  |  | 5 | C | 4
 |  |  | 5 | C | 5
 |  |  | 5 | B | 3
 |  |  | 5 | C | 4
 |  |  | 5 | A | 5
 |  |  | 5 | C | 1
 |  |  | 6 | B | 2
 |  |  | 6 | A | 4
 |  |  | 6 | C | 5
 |  |  | 6 | B | 3
 |  |  | 7 | C | 4
 |  |  | 7 | A | 5
 |  |  | 7 | C | 1
 |  |  | 7 | B | 2
 |  |  | 7 | A | 4
 |  |  | 7 | C | 5
 |  |  | 7 | B | 3
 |  |  | 7 | C | 4
 |  |  | 7 | A | 5
 |  |  | 7 | C | 1
 |  |  | 7 | B | 2
 |  |  | 7 | A | 4
 |  |  | 7 | C | 5
 |  |  | 7 | B | 3
 |  |  | 7 | C | 4
 |  |  | 8 | A | 5
 |  |  | 8 | C | 1
 |  |  | 8 | B | 2
 |  |  | 8 | C | 4
 |  |  | 8 | B | 5
 |  |  | 8 | C | 3
 |  |  | 8 | A | 4
 |  |  | 9 | C | 5
 |  |  | 9 | B | 1
 |  |  | 9 | A | 2
 |  |  | 9 | C | 4
 |  |  | 9 | B | 5
 |  |  | 9 | C | 3
 |  |  | 9 | A | 4
 |  |  | 9 | B | 5
 |  |  | 10 | C | 2
 |  |  | 10 | A | 3
 |  |  | 10 | A | 4
Spreadsheet: louise_kitchen__23955__SepYTD Orig w notes sf
Sheet: HPL

HPL
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Gottlob |  | Gas |  | HPL |  | 5749630
Riley |  | Gas |  | HPL |  | 1546776
Morris |  | Gas |  | HPL |  | 723434
Hall |  | Gas |  | HPL |  | 216719
Snieder |  | Gas |  | HPL
Lamphier |  | Gas |  | HPL
[NAME] |  | Gas |  | HPL |  | 43010
[NAME] |  | Gas |  | HPL |  | 37419
Weissman |  | Gas |  | HPL |  | 12580
Lofton |  | Gas |  | HPL |  | 10149
Peyton |  | Gas |  | HPL |  | 2431
[NAME] |  | Gas |  | HPL |  | -42841
Papayoti |  | Gas |  | HPL
Total
Spreadsheet: 178528d1346829639-nested-if-statement-with-and-statement-example
Sheet: Sheet1

Level 1 Creative Website Design (Entry Level) | Designed for clients new to eCommerce with no existing eCommerce Website. Includes, Creative Design Level 1 design service, Multilevel Menus, 1hr Design Consultancy, Written Design Brief, 20hrs Design and Project Time, Google Analytics, Process and Browser Testing, SEO Migration Service |  |  |  |  |  |  |  |  |  |  |  | 2200
Level 1 Starter Hosting  2GB BW+2[NAME] | SSL, L1 Hosting, Zoom Image Space |  |  |  |  |  |  |  |  |  |  |  | 0 | 27.5
Level 1 eCommerce Engine | Shopping engine, mgnt system, support and updates. Up to 50 sales a month. |  |  |  |  |  |  |  |  |  |  |  | 0 | 14
Level 2 Creative Website Design (Entry Level) |  |  |  |  |  |  |  |  |  |  |  |  | 4300
Level 1 Starter Hosting  2GB BW+2[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 27.5
Level 2 eCommerce Engine |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 14
Level 3 Creative Website Design (Entry Level) |  |  |  |  |  |  |  |  |  |  |  |  | 9000
Level 2 Hosting  2GB BW+2[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 39.5
Level 3 eCommerce Engine |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 14
Upgrade Level 1 Starter Hosting to Level 2 Hosting |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 12
Level 1 mCommerce Connect |  |  |  |  |  |  |  |  |  |  |  |  | 470 | 0 | 70.5
Level 2 mCommerce Connect |  |  |  |  |  |  |  |  |  |  |  |  | 780
Level 3 mCommerce Connect |  |  |  |  |  |  |  |  |  |  |  |  | 1570
Spreadsheet: 781921d1653645155-average-sales-per-year-averageif-averageif
Sheet: Sheet1

DATE | AMOUNT |  | AVERAGE PER YEAR
2003-01-02 00:00:00 | 7024 |  | 2000 | 2001 | 2002 | 2003
2001-01-02 00:00:00 | 1514
2000-01-03 00:00:00 | 8792
2002-01-09 00:00:00 | 1445
2001-01-09 00:00:00 | 3386
2003-01-13 00:00:00 | 4533
2001-01-13 00:00:00 | 7369
2000-01-22 00:00:00 | 4816
2000-01-23 00:00:00 | 1953
2002-01-25 00:00:00 | 8646
2001-01-25 00:00:00 | 1927
2002-01-26 00:00:00 | 1720
2000-01-26 00:00:00 | 714
2003-01-28 00:00:00 | 3865
2000-01-29 00:00:00 | 6944
2000-01-30 00:00:00 | 8504
Spreadsheet: 154660d1336505673-formula-to-find-values-in-table-various-locations-sample_vlookup
Sheet: Sheet2

[NAME]
 | Group | PPL | Date | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00
 | A | 11 | 14 | 07:00 - 09:00 2hrs |  |  |  |  |  |  | Group # | Session Date | Session Times
 | B | 12 | 15 |  | 07:00 - 09:00 2hrs |  |  |  |  |  | A
 | C | 12 | 16 |  |  | 07:00 - 09:00 2hrs |  |  |  |  | B
 | D | 6 | 18 |  |  |  |  | 07:00 - 09:00 2hrs |  |  | C
 | E | 11 | 14 | 10:00 - 12:00 2hrs |  |  |  |  |  |  | D
 | F | 11 | 15 |  | 10:00 - 12:00 2hrs |  |  |  |  |  | E
 | G | 10 | 16 |  |  | 10:00 - 12:00 2hrs |  |  |  |  | F
 | H | 11 | 14 | 14:00 - 16:00 2 hrs |  |  |  |  |  |  | G
 | I | 11 | 15 |  | 14:00 - 16:00 2 hrs |  |  |  |  |  | H
 | J | 11 | 16 |  |  | 14:00 - 16:00 2 hrs |  |  |  |  | I
 | K | 11 | 17 |  |  |  | 17:00 - 19:00 2 hrs |  |  |  | J
 | L | 11 | 18 |  |  |  |  | 14:00 - 16:00 2 hrs |  |  | K
 | M | 11 | 14 | 17:00 - 19:00 2 hrs |  |  |  |  |  |  | L
 | N | 11 | 15 |  | 17:00 - 19:00 2 hrs |  |  |  |  |  | M
 | O | 7 | 16 |  |  | 17:00 - 19:00 2 hrs |  |  |  |  | N
 | P | 3 | 17 |  |  |  | 22:00 - 00:00 2 hrs |  |  |  | O
 | Q | 2 | 16 |  |  | 22:00 - 00:00 2 hrs |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | Q
Spreadsheet: jay_reitmeyer__13543__dailyrox2fcst
Sheet: Map

 |  | Kemmerer |  |  |  | [NAME]
 |  | Deliveries |  |  |  | Deliveries
 |  |  |  |  |  |  |  |  |  |  | Med Bow
 |  |  | Opal
 |  |  |  |  |  |  |  |  |  |  |  | East Outlet Deliveries
 |  |  |  |  |  |  | CIG
 |  |  |  |  |  |  |  |  |  |  |  |  | TRBLZ
 |  |  |  | Clay Basin
 |  | Questar
 |  |  |  |  | Rockies Receipts
Kern Deliveries |  |  |  |  |  |  |  |  |  |  |  |  | CIG Storage
 |  | NWPL
 | San Juan Receipts
 |  |  |  |  |  |  |  | Day/Month: | Day
 |  |  |  |  |  |  |  | Date: | 2001-08-21 00:00:00
 | SJ Triangle
 |  |  | TW Triangle
Spreadsheet: 100003d1298494352-how-do-i-import-data-from-another-sheet-to-match-certain-criteria-test-page-excel-assistance
Sheet: Sheet Y

Emp. Number | Name | Audit Code
451321 | Rita | 912323696
451321 | Rita | 912323696
451321 | Rita | 912323696
486512 | [NAME] | 945984212
486512 | [NAME] | 945984212
498498 | [NAME] | 932132133
498498 | [NAME] | 932132133
498498 | [NAME] | 932132133
484948 | Alonzo | 936998888
484948 | Alonzo | 936998888
484948 | Alonzo | 936998888
498516 | [NAME] | 913232116
498516 | [NAME] | 913232116
498516 | [NAME] | 913232116
433212 | [NAME] | 936996365
433212 | [NAME] | 936996365
468988 | [NAME] | 993216516
468988 | [NAME] | 993216516
468988 | [NAME] | 993216516
489321 | Christina | 913219988
489321 | Christina | 913219988
489321 | Christina | 913219988
489321 | Christina | 913219988
489302 | [NAME] | 985369699
489302 | [NAME] | 985369699
489302 | [NAME] | 985369699
456898 | [NAME] | 912365456
456898 | [NAME] | 912365456
456898 | [NAME] | 912365456
456898 | [NAME] | 912365456
489877 | [NAME] | 926136516
489877 | [NAME] | 926136516
489877 | [NAME] | 926136516
489877 | [NAME] | 926136516
Spreadsheet: 273f03e3-b93e-47fe-afb1-c02295114ed3
Sheet: Sheet1

Value of the WPU | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
FYs 1976-2006
Fiscal | WPU | Dollar | Year to Year
Year | Value | Change | % Increase
1976 | 621
1977 | 683 | 62 | 0.0998389694041868
1978 | 732 | 49 | 0.07174231332357248
1979 | 795 | 63 | 0.0860655737704918
1980 | 852 | 57 | 0.07169811320754717
1981 | 946 | 94 | 0.1103286384976526
1982 | 1003 | 57 | 0.06025369978858351
1983 | 1103 | 100 | 0.09970089730807577
1984 | 1103 | 0 | 0
1985 | 1124 | 21 | 0.01903898458748867
1986 | 1180 | 56 | 0.0498220640569395
1987 | 1204 | 24 | 0.02033898305084746
1988 | 1204 | 0 | 0
1989 | 1204 | 0 | 0
1990 | 1240 | 36 | 0.02990033222591362
1991 | 1346 | 106 | 0.08548387096774193
1992 | 1408 | 62 | 0.04606240713224369
1993 | 1490 | 82 | 0.05823863636363636
1994 | 1539 | 49 | 0.03288590604026845
1995 | 1608 | 69 | 0.04483430799220273
1996 | 1672 | 64 | 0.03980099502487562
1997 | 1739 | 67 | 0.04007177033492823
1998 | 1791 | 52 | 0.02990224266820012
1999 | 1854 | 63 | 0.03517587939698492
2000 | 1901 | 47 | 0.02535059331175836
2001 | 2006 | 105 | 0.05523408732246186
2002 | 2116 | 110 | 0.05483549351944168
2003 | 2132 | 16 | 0.007561436672967864
2004 | 2150 | 18 | 0.008442776735459663
2005 | 2182 | 32 | 0.01488372093023256
2006 | 2280 | 98 | 0.04491292392300641
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Loom

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 65b4f7d6-af42-4451-b3df-037a239dd0d7
Sheet: Sheet1

Disbursements by Finland from January 1 to December 31, 2007 | Unnamed: 1
in Euro / Suomen maksatukset Tansanialle 1.1.-31.12.2007 (EURO)
Local Government Reform Programme/ Paikallishallintouudistus | 5000000
Poverty Reduction Budget Support/ Tuki köyhyyden vähentämisrahastolle | 8600000
Funds for Local Cooperation (LCF)/ Paikallisen yhteistyön määräraha (PYM) | 888209
National Forest Programme/ Tuki kansalliselle metsäohjelmalle | 136269
Local Government Capital Development [NAME] valtionosuusjärjestelmän kehittäminen | 3000000
Sustainable Management of Land and Environment in Zanzibar (SMOLE)/ Sansibarin integroitu maankäyttö ja ymp.hall.tuki | 860818
District Economic and Social Empowerment Programme (DESEMP)/ Paikallisten elinkeinojen kehittämishanke | 346106
Political Parties of Finland for Democracy/ Puolueiden demokratiadialogi | 145
Special Needs Education Programme/ Inklusiivisen erityisopetuksen tuki | 383343
Education Sector follow-up/Opetussektorin seuranta | 12679
One UN Pilot Programme/ Yksi YK Pilottiohjelma | 1000000
Programme planning/ Hankkeiden suunnittelu | 135113
 | 20362682
[NAME] apu | 200000
Support to Finnish NGOs/ Tuki [NAME] | 1467519
total / yhteensä | 22030201
Spreadsheet: 00ee7db3-4490-41fd-a316-5b9b8d4d60dc
Sheet: Sheet1

FY 2014 Perkins Budget Worksheet
 | Line Item | Invoice/PO Number | Item/Explanation | Sub-Total | Total
1 | Advisory Committee
2 | CTSO's
3 | Curriculum Development
3 | Consultant Fees
4 | Equipment
5 | Externships
6 | Grant Writer/Coordinator
7 | Guidance/Counseling
8 | Honorariums
9 | Materials
10 | Memberships
11 | Registration Fees
12 | Resources
13 | Software
14 | Subscriptions
15 | Substitutes
16 | Supplies
17 | Travel Expenses
18 | Other
19 | Administrative Costs
 | Total Expenses
Spreadsheet: 116236d1311693054-excel-2008-dsum-or-subtotal-with-dynamic-criteria-from-a-large-list-sample_truck_loading_log
Sheet: TruckLoadingLog

 | Truck Loading Log |  |  |  |  | Date:
 | Customer: |  |  | Bay: |  | Van:
 | Commodity |  | Tag # | Gross |  | Tare | Net |  | Loaded
1) | Commodity 1 |  | 100 | 1500 |  | 45 |  |  | 1 | G
2) | Commodity 1 |  | 123 | 1345 |  | 42 |  |  | 1 | P
3) | Commodity 1 |  | 143 | 2000 |  | 45 |  |  | 1 | G
4) | Commodity 1 |  | 136 | 1234 |  | 80 |  |  | 2 | P
5)
6) | Commodity 14 |  | 157 | 2000 |  | 0 |  |  | 2 | B
7) | Commodity 14 |  | 547 | 1432 |  | 0 |  |  | 1 | B
8) | Commodity 14 |  | 857 | 1322 |  | 0 |  |  | 1 | B
9)
10) | Commodity 7 |  | 432 | 526 |  | 77 |  |  | 2 | P
11) | Commodity 7 |  | 654 | 639 |  | 74 |  |  | 1 | P
12) | Commodity 7 |  | 321 | 776 |  | 63 |  |  | 1 | G
13) | Commodity 7 |  | 109 | 653 |  | 68 |  |  | 1 | G |  | Subtotals
14) | Commodity 7 |  | 987 | 537 |  | 61 |  |  | 1 | G
15) |  |  |  |  |  |  |  |  |  |  |  | Commodity 1 |  |  | Gross | Tare | Net | B | G | P | Loaded
16) | Commodity 31 |  | 478 | 1432 |  | 0 |  |  | 1 | B |  |  |  |  |  |  |  | 0 | 2 | 3 | 5
17) | Commodity 31 |  | 353 | 2240 |  | 0 |  |  | 1 | B |  | Commodity 14 |  |  | Gross | Tare | Net | B | G | P | Loaded
18) | Commodity 31 |  | 121 | 1356 |  | 0 |  |  | 1 | B |  |  |  |  |  |  |  | 4 | 0 | 0 | 4
19) | Commodity 31 |  | 456 | 1453 |  | 0 |  |  | 2 | B |  | Commodity 7 |  |  | Gross | Tare | Net | B | G | P | Loaded
20) | Commodity 31 |  | 789 | 1643 |  | 0 |  |  | 2 | B |  |  |  |  |  |  |  | 0 | 3 | 3 | 6
21) | Commodity 31 |  | 980 | 1568 |  | 0 |  |  | 1 | B |  | Commodity 31 |  |  | Gross | Tare | Net | B | G | P | Loaded
22) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 8 | 0 | 0 | 8
23) | Commodity 26 |  | 128 | 1100 |  | 40 |  |  | 1 | G |  | Commodity 26 |  |  | Gross | Tare | Net | B | G | P | Loaded
24) | Commodity 26 |  | 727 | 1010 |  | 43 |  |  | 1 | G |  |  |  |  |  |  |  | 0 | 3 | 1 | 4
25) | Commodity 26 |  | 356 | 1254 |  | 39 |  |  | 1 | G |  | Commodity 12 |  |  | Gross | Tare | Net | B | G | P | Loaded
26) | Commodity 26 |  | 764 | 1222 |  | 41 |  |  | 1 | P |  |  |  |  |  |  |  | 0 | 1 | 3 | 4
27) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
28) | Commodity 12 |  | 1364 | 1553 |  | 82 |  |  | 1 | G
29) | Commodity 12 |  | 1242 | 1437 |  | 85 |  |  | 2 | P |  |  |  |  | Gross | Tare | Net | B | G | P | Loaded
30) | Commodity 12 |  | 6543 | 423 |  | 78 |  |  | 1 | P
31)
32)
33)
34) |  |  |  |  |  |  |  |  |  |  |  | Total Gross |  | Total Tare |  | Total Net
35)
36)
37)
38) |  |  |  |  |  |  |  |  |  |  |  | Total Units Loaded:
39)
40) |  |  |  |  |  |  |  |  |  |  |  | Bales: |  | Gaylords: |  | Pallets:
41)
Spreadsheet: 882373d1730746107-function-to-return-the-number-of-columns-which-contain-information-book444
Sheet: Sheet1

Wed, Sep 18, 2024 | Wed, Sep 25, 2024 | Wed, Oct 2, 2024 | Wed, Oct 9, 2024 | Wed, Oct 16, 2024 | Wed, Oct 23, 2024 | Wed, Oct 30, 2024 | Wed, Nov 6, 2024 | Wed, Nov 13, 2024 | Wed, Nov 20, 2024 | Wed, Nov 27, 2024 | Wed, Dec 4, 2024
P | P | 2 | P | 2
P | 2 | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P |  |  |  |  |  |  |  |  | output
P | 2 | 2 | P | P |  |  |  |  |  |  |  |  | Number of columns which contain information (text or number)= 4 column
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
Spreadsheet: kimberly_watson__20583__PA AGAVE TW IC
Sheet: Settlement Rule Percentage

Project Definition |  | Project Title
Project WBS
WBS | Cost | PS |  |  |  |  | Current | Settlement
Element | Element | Asset | Materials |  |  |  | Cost | Percentage
.06 | 53500500
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
.06
Spreadsheet: c83c70ff-f3ae-4099-82b3-82e20b566390
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ROTA | Test | ROTA | [NAME], Feces | [NAME], F | Enzyme Immunoassay (EIA) | [NAME], sterile container: SrwStlCont |  |  | 10 | g | Container/Tube:  Preferred: Sterile stool container Acceptable: Swab [NAME]: 5-10 g Additional Information: Place specimen in a tightly-sealing plastic bag. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 5 g | Hemolysis	NA Thawing	Warm Reject; Cold OK Lipemia	NA Icterus	NA Other	Grossly bloody (containing no visible stool) or very mucoid stool | Negative | Monday through Sunday | 1 day | 2 days | 1 | 87425 |  |  |  |  | Rochester
ROTA | [NAME] | FECAL | Fecal |  |  |  | Frozen | 7 days
ROTA | Result | 24082 | [NAME], F | [NAME], F | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5880-0 | [NAME]:ACnc:Pt:Stool:Ord:EIA
Spreadsheet: 849827d1700208926-account-closing-with-conditional-day-addition-account-closign
Sheet: Sheet1

closing date : | 4
Date | Product | Account | closing date | Amount
2023-11-03 00:00:00 | Computer |  | 2023-11-04 00:00:00 | 125
2023-11-04 00:00:00 | Pc |  | 2023-11-04 00:00:00 | 250
2023-11-04 00:00:00 | Telephone |  | 2023-11-04 00:00:00 | 375
2023-11-04 00:00:00 | Fast food |  | 2023-11-04 00:00:00 | 525
2023-11-05 00:00:00 | Tv |  | 2023-12-04 00:00:00 | 1125
2023-11-06 00:00:00 | Mop |  | 2023-12-04 00:00:00 | 250
2023-12-03 00:00:00 | tv |  | 2023-12-04 00:00:00 | 700
 | Accounts open until the 4th of the month must be closed on the 4th day of the relevant month.
 | That is, it is valid for that month, including the 4th day of the month.
 | Dates after the 4th day of the month must close on the 4th day of the following month.
 | For example, the closing date of an invoice dated 5 November will be 4 December.