tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 195621d1353584491-cannot-get-indirect-function-to-work-with-sumifs-ef272_inv-summary-test
Sheet: Sheet 1

 | Invoice Number | Date | Amount
 | CEL 61.xls | 2012-09-30 00:00:00 | 1200
 | CEL 60.xls | 2012-08-31 00:00:00 | 250
 | CEL 59.xls | 2012-08-31 00:00:00 | 1200
 | CEL 58E.xls | 2012-07-31 00:00:00 | 209.46
 | CEL 57.xls | 2012-07-31 00:00:00 | 900
 | CEL 56.xls | 2012-06-30 00:00:00 | 1500
 | CEL 55.xls | 2012-05-31 00:00:00 | 1500
 | CEL 54.xls | 2012-04-30 00:00:00 | 1500
 | CEL 53E.xls | 2012-03-31 00:00:00 | 44.03
 | CEL 52.xls | 2012-03-31 00:00:00 | 1500
 | CEL 51E.xls | 2012-02-29 00:00:00 | 97.69
 | CEL 50.xls | 2012-02-29 00:00:00 | 1500
 | CEL 49.xls | 2012-01-31 00:00:00 | 1500
 | CEL 48E.xls | 2012-01-31 00:00:00 | 71.4
 | CEL 47.xls | 2011-12-31 00:00:00 | 1500
 | CEL 46E.xls | 2011-12-20 00:00:00 | 367.75
 | CEL 45.xls | 2011-11-30 00:00:00 | 681.31
 | CEL 44E.xls | 2011-11-30 00:00:00 | 255.52
 | CEL 43.xls | 2011-11-30 00:00:00 | 1500
 | CEL 42.xls | 2011-10-31 00:00:00 | 1500
 | CEL 41.xls | 2011-09-30 00:00:00 | 1500
 | CEL 40.xls | 2011-08-31 00:00:00 | 1500
 | CEL 39 Ex.xls | 2011-08-06 00:00:00 | 1084.93
 | CEL 38.xls | 2011-07-31 00:00:00 | 1500
 | CEL 37.xls | 2011-06-30 00:00:00 | 1500
 | CEL 36.xls | 2011-05-31 00:00:00 | 1500
 | CEL 35.xls | 2010-12-31 00:00:00 | 818.47
 | CEL 34.xls | 2010-10-31 00:00:00 | 1259.95
 | CEL 33.xls | 2010-10-31 00:00:00 | 221.05
 | CEL 32.xls | 2010-10-31 00:00:00 | 620.55
 | CEL 31.xls | 2010-10-31 00:00:00 | 624.68
 | CEL 30E.xls | 2010-05-31 00:00:00 | 471.96
 | CEL 30.xls | 2009-09-30 00:00:00 | 1422.43
 | CEL 29.xls | 2009-05-31 00:00:00 | 514.2
 | CEL 28.xls | 2009-04-30 00:00:00 | 532.07
 | CEL 27.xls | 2009-03-31 00:00:00 | 369.1
 | CEL 26.xls | 2008-09-07 00:00:00 | 2240.3
 | CEL 25.xls | 2007-12-03 00:00:00 | 360.18
 | CEL 24.xls | 2007-10-15 00:00:00 | 454.9
 | CEL 23.xls | 2005-08-31 00:00:00 | 469.03
 | CEL 22.xls | 2005-07-21 00:00:00 | 352.73
 | CEL 21.xls | 2005-05-18 00:00:00 | 1250.56
 | CEL 20.xls | 2005-01-31 00:00:00 | 109.05
 | CEL 19.xls | 2004-07-17 00:00:00 | 425.28
 | CEL 18.xls | 2004-04-30 00:00:00 | 862.56
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 10b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 1865841 | 592024 | 831707 | 5713735 | 516050 | 123723 | 376521 | 10019601
Cross-Currency Fixed-Fixed | 55170 | 44649 | 31306 | 226511 | 9484 | 28378 | 31554 | 427052
Cross-Currency Fixed-Float | 127008 | 42183 | 63152 | 327493 | 50607 | 16892 | 635169 | 1262504
TOTAL | 2048019 | 678856 | 926165 | 6267739 | 576141 | 168993 | 1043244 | 11709157
Spreadsheet: 839589d1692103899-weekly-reporting-formula-check-jul_wk4-data_test-1-
Sheet: Willona

Agent's name: |  | Date:
Weekly RingCentral Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Weekly CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Previous Week Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Previous Week's CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 52446d1252162425-convert-data-horizontal-to-vertical-book1
Sheet: Sheet1

11 | A | B | C | D | E | F | G | H
22 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
33 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
44 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
A | 22 | 1
A | 33 | 2
A | 44 | 3
B | 22 | 2
B | 33 | 3
B | 44 | 4
C | 22 | 3
C | 33 | 4
C | 44 | 5
D | 22 | 4
D | 33 | 5
D | 44 | 6
E | 22 | 5
E | 33 | 6
E | 44 | 7
F | 22 | 6
F | 33 | 7
F | 44 | 8
G | 22 | 7
G | 33 | 8
G | 44 | 9
H | 22 | 8
H | 33 | 9
H | 44 | 0
#N/A | 22 | #N/A
#N/A | 33 | #N/A
#N/A | 44 | #N/A
#N/A | 22 | #N/A
#N/A | 33 | #N/A
#N/A | 44 | #N/A
#N/A | 22 | #N/A
#N/A | 33 | #N/A
#N/A | 44 | #N/A
#N/A | 22 | #N/A
#N/A | 33 | #N/A
#N/A | 44 | #N/A
#N/A | 22 | #N/A
#N/A | 33 | #N/A
#N/A | 44 | #N/A
#N/A | 22 | #N/A
#N/A | 33 | #N/A
#N/A | 44 | #N/A
#N/A | 22 | #N/A
#N/A | 33 | #N/A
#N/A | 44 | #N/A
#N/A | 22 | #N/A
#N/A
Spreadsheet: 588306d1535555712-sumif-with-condition-example-sumifs
Sheet: Tab 2

Acct | Total Cost | Type
ABC123 | 350 | Trucks
ABC123 | 150 | Cars
ABC123 | 250 | SUV
ABC123 | 300 | SEDANS
DEF456 | 550 | Trucks
DEF456 | 150 | Cars
DEF456 | 250 | SUV
DEF456 | 300 | SEDANS
Spreadsheet: 886979d1737052922-find-and-highlight-multiple-names-across-entire-sheet-example_-eozkired
Sheet: Sheet1

Team |  | PHL | SXM | MUC | LAX
BOB |  | BOB | TINA | JOE | HANNA
JOE |  | DAN | RICH | GLEN | [NAME]
[NAME] |  | LYNN | BRIT | [NAME] | BILL
TINA |  | [NAME] | brit | SAM | BOB
bob |  | ALEX |  | ALEX | TINA
 |  |  |  | LYNN | SVEN
 |  |  |  |  | [NAME]
 |  |  |  | [NAME] | TAYLOR
 |  |  |  |  | HANK
 |  |  |  |  | tina
Spreadsheet: 853208d1703109728-need-help-getting-lambda-to-work-scheduling-kansas-2-1-
Sheet: Data

Press List |  | Printers |  | Employee Names |  | Finishing |  | Guillotine |  |  | [NAME]
[NAME] |  | [NAME] |  | Adrian Samano |  | Darrell Billingsley |  | [NAME] |  |  | HP/ 3R Formula
3R |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  |  | GS Formula
HP |  | [NAME] |  | [NAME] |  |  |  |  |  |  | HS Formula
HS 125 |  | Crystal [NAME] |  | [NAME]
GS 3250 |  | [NAME] |  | [NAME]
[NAME] |  | [NAME] |  | [NAME]
Indigo |  | [NAME] |  | [NAME]
Cut Only |  | [NAME] |  | [NAME]
 |  | [NAME] |  | [NAME]
Laminator |  | Micah [NAME] |  | [NAME]
Zund 1 |  | [NAME] |  | [NAME]
[NAME] |  | Troy Schartz |  | [NAME]
Zund 3 |  | [NAME]
[NAME] |  | [NAME]
Guillotine
[NAME]
Spreadsheet: 96839d1296114656-excel-2007-help-with-table-weekly-journey-planner-sales-report
Sheet: Week 2

Weekly Journey Planner
Date- |  |  | week | Code
SID- |  | 200 | 2
Reps Name-
Acc No: | Owners Name: | Salon Name | Address | Suburb | Telephone | Sid | Week | Day | Week - Day | Focus 1 | Pres | Acc | Remarks | Focus 2 | Pres | Acc | Remarks | Focus 3 | Pres | Acc | Remarks | Focus 4 | Pres | Acc | Remarks | Focus 5 | Pres | Acc | Remarks
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Y | N | 2. Deal too big
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | Y | N | 3. Not interested
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Y | N | 2. Deal too big
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | Y | N | 3. Not interested
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Y | N | 2. Deal too big
 |  |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  | N
Count |  |  |  |  | Overall | Overall
 |  |  |  |  | Day 1 | Day 1
 |  |  |  |  | Day 2 | Day 2
 |  |  |  |  | Day 3 | Day 3
 |  |  |  |  | Day 4 | Day 4
 |  |  |  |  | Day 5 | Day 5
Pres = Presented  Y or N
Acc = Accepted  Y or N
Drop Down Settings
Y | Y | Y |  | 1. Too Expensive
N | Y | N |  | 2. Deal too big
 |  |  |  | 3. Not interested
 |  |  |  | 4. Bad Selling Technique
Spreadsheet: 89f41cad-f6b4-47ad-8c56-93892ec594fb
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
FFTGI | Test | FFTGI | [NAME] and IgM, CSF | [NAME] and IgM, CSF | Enzyme Linked Immunosorbent Assay (ELISA) | [NAME], sterile container: SrwStlCont |  |  | 1 | mL | 1 mL of spinal fluid (CSF) sent refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reference Range:  IgG:	<0.90 IgM:	<0.80   INTERPRETIVE CRITERIA:   [NAME]: 	<0.90		Antibody not detected 	0.9 - 1.09	Equivocal 	> or = 1.10	Antibody detected   	IgM: 	<0.80		Antibody not detected 	0.80 - 0.99	Equivocal 	> or = 1.00	Antibody detected   Diagnosis of central nervous system infections can be accomplished by demonstrating the presence of intrathecally-produced specific antibody. Interpreting results may be complicated by low antibody levels found in CSF, passive transfer of antibody form blood, and contamination via bloody taps.  The interpretation of CSF results must consider CSF-serum antibody ratios to the infectious agent.    Test Performed by:	Focus Diagnostics, Inc.  			5785 Corporate Avenue 			Cypress, CA 90630-4750 | Tuesday, Friday | 1 - 5 days | 3 - 7 days |  | Profile |  |  |  |  | Focus Diagnositics, Inc.
FFTGI | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
FFTGI | Result | Z0665 | [NAME] | [NAME] | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTGI | Result | Z0341 | T. Gondii IgM | T. Gondii IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTGI | Billing Component | FFTGI |  | T. Gondii IgM |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86778
FFTGI | Billing Component | FFTGI |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 86777
Spreadsheet: 845503d1697007903-vlookup-when-multiple-fields-are-needed-vlookup
Sheet: Sheet1

Name ID | Military ID | Medal | Quantity |  | Quantity | Military | ID | + | Name | ID
[PHONE] | 987654321 | 1 |  |  | 500
888888888 | 6666666 | 2 |  |  | 700 | 6666666888888888
Spreadsheet: 768497d1645001401-trying-to-look-up-and-filter-data-example
Sheet: C

 | Id numeric | Product | Brew number | Sampling point | Analysis | Component name | Result text
998462 | 998462 | KROC | 202200010 |  | COL | COL | 6.6
998462 | 998462 | KROC | 202200010 |  | DO2 | DO2 | 85
998462 | 998462 | KROC | 202200010 |  | PH | PH | 4.5
998462 | 998462 | KROC | 202200010 |  | VISUAL | VISUAL | PASS
998463 | 998463 | KROC | 202200010 |  | COL | COL | 6.7
998463 | 998463 | KROC | 202200010 |  | DO2 | DO2 | 65
998463 | 998463 | KROC | 202200010 |  | PH | PH | 4.49
998463 | 998463 | KROC | 202200010 |  | VISUAL | VISUAL | PASS
998465 | 998465 | KROC |  |  | COL | COL | 6.9
998465 | 998465 | KROC |  |  | OE | OE | 11
998465 | 998465 | KROC |  |  | PH | PH | 4.49
998465 | 998465 | KROC |  |  | PU | PU | 19.3
998465 | 998465 | KROC |  |  | PU | TIME | 1700
998465 | 998465 | KROC |  |  | SO2 | SO2 | 9.2
998465 | 998465 | KROC |  |  | TPO | TPO | 85
998465 | 998465 | KROC |  |  | TPO | TPO | 77
998465 | 998465 | KROC |  |  | TPO_AVE | TPO_AVE | 81
998465 | 998465 | KROC |  |  | VIRTUAL_PU | VIRTUAL PU | 13.9
998465 | 998465 | KROC |  |  | VISUAL | VISUAL | PASS
998467 | 998467 | KROC | 202200010 |  | COL | COL | 6.8
998467 | 998467 | KROC | 202200010 |  | PH | PH | 4.47
998656 | 998656 | REDC |  |  | COL | COL | 6.9
998656 | 998656 | REDC |  |  | OE | OE | 10.83
998656 | 998656 | REDC |  |  | PH | PH | 4.2
998656 | 998656 | REDC |  |  | SO2 | SO2 | 8.2
998656 | 998656 | REDC |  |  | TPO | TPO | 98
998656 | 998656 | REDC |  |  | TPO | TPO | 110
998656 | 998656 | REDC |  |  | TPO_AVE | TPO_AVE | 104
998656 | 998656 | REDC |  |  | VISUAL | VISUAL | PASS
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: WAHA_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  | 21 | 2.405 |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 | 3 | 2.35 |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 763519d1642209675-lookup-where-there-are-approximate-matches-with-the-lookup-value-how-to-achieve-lookup-approximate-matches-alijay64-
Sheet: Records Unexpected Usage

This table shows unexpected usage which is associated with a set of possible part numbers. | B85244 Oracle Fusion Planning Central Cloud Service - Hosted 1000 Planned Item Locations | B87766 Oracle Demand Management Cloud Service - Hosted 1,000 Planned Item Locations | B87768 Oracle Supply Planning Cloud Service - Hosted 1,000 Planned Item Locations | B87770 Oracle Sales and Operations Planning Cloud Service - Hosted 1,000 Planned Item Locations
 | B85244 | B87766 | B87768 | B87770
2021-05-01 00:00:00 | 448272 | 448272 | 448272 | 448272
2021-06-01 00:00:00 | 987276 | 987276 | 987276 | 987276
2021-07-01 00:00:00 | 1199775 | 1199775 | 1199775 | 1199775
2021-08-01 00:00:00 | 1217341 | 1217341 | 1217341 | 1217341
Spreadsheet: 468e35b4-8f7c-4394-93bb-2feefd669e30
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4436 | 5708 | [NAME] | Lessing | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:59:47
4436 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | [NAME]
4436 | 10349 | [NAME] | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:02:07
Spreadsheet: 728413d1618435864-ifs-formula-that-allows-whole-and-decimals-rea-point-tracker-test
Sheet: Monday

Monday | 2021-04-12 00:00:00 | Day Shift |  |  |  |  |  | Swing Shift
Last Name | First Name | Behavior / Attitude | Relationships (staff/peers) | Program/School/GEO | Personal/Room Appearance | Furlough/Outing | Shift Total | Behavior / Attitude | Relationships (staff/peers) | Program/School/GEO | Personal/Room Appearance | Furlough/Outing | Shift Total | Today's Score | REA Bucks | Weekly Average | Weekly REA Bucks
Spreadsheet: louise_kitchen__22561__EWS Spend and Approval
Sheet: Sheet1

Workflow Title | Spend Limit | Substitute or "Forward to" | Approver Limit | Role | Revised Spend Limit
Contractors, Specialists, Sr. Specialists Job Codes: 8,9,10,11,12,19,22 | 0 | Not Applicable | 0 | Requestor Only
Sr. [NAME],  Job Codes: 13,14,17,18 | up to $250 | All Users | up to $250 | Requestor/Approver
Exec Coordinators Exec Assist (Peggy & Tina) Job Codes: 16,20 | up to $500 | All Users | up to $500 | Requestor/Approver
Manager Job Codes: 6, 7 | up to $5,000 | All Users | up to $5,000 | Requestor/Approver
Director Job Code: 5 | up to $25,000 | All Users | up to $25,000 | Requestor/Approver
Sr. Director Job Code: 4 | up to $50,000 | All Users | up to $50,000 | Requestor/Approver
Vice President Job Code: 3 | up to $100,000 | All Users | up to $100,000 | Requestor/Approver
VP Exceptions - [NAME] and [NAME] Code: 3 | up to $250,000 | All Users | up to $250,000 | Requestor/Approver
Managing Director Job Code: 2 | up to $1,000,000 | All Users | up to $1,000,000 | Requestor/Approver
Office of the Chair Job Code: 1 | up to $5,000,000 | All Users | up to $5,000,000 | Requestor/Approver
Spreadsheet: 1d728b6f-56ed-46f1-ae11-c52e2259c9fc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15b. MERCHANDISE [NAME], State and Australia, Customs Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829564W | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829565X | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829566A | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829567C | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829568F | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829569J | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829570T | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829571V | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A2529326T | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
Total (State of Final Destination) ; |  |  | Original | A1829572W | 1988-01-01 00:00:00 | 2012-10-01 00:00:00 | 298 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 675935d1588573294-roster-pay-with-4-different-wages-based-on-time-period-roster-pay-1-
Sheet: Rate

Pay Rates
Weekdays |  | Am Premium |  | Normal Trading |  | Evening Premium |  | Pm Premium
MON - FRI | % | 1.75 |  | 1 |  | 1.25 |  | 1.75
 | RATE |  |  | 23.69
 | Time Intervals | 00:00:00 | 06:59:00 | 07:00:00 | 17:59:00 | 18:00:00 | 22:59:00 | 23:00:00 | 23:59:00
Saturdays |  | Am Premium |  | Normal Trading |  | Evening Premium |  | Pm Premium
 | % | 1.75 |  | 1 |  | 1.25 |  | 1.75
 | RATE |  |  | 23.69
 | Time Intervals | 00:00:00 | 06:59:00 | 07:00:00 | 17:59:00 | 18:00:00 | 22:59:00 | 23:00:00 | 23:59:59
Sundays |  | Sunday One Day Rate |  |  | Public Holiday |  | Public Holiday Rate
 | % | 1.75 |  |  |  | % | 1.75
 | RATE |  |  |  |  | RATE
 | Time Intervals | 00:00:00 | 23:59:59 |  |  | Time Intervals | 00:00:00 | 23:59:59
Spreadsheet: d63d51e0-a6d4-49d1-a6ac-2d581bbd085f
Sheet: Sheet1

Name | Add1 | CSZ | phone | fax | e-mail | [NAME]
ARC Welding Co., Inc. | 44 [NAME] Street | Waltham, MA  02454 | [PHONE] |  | [EMAIL]
Atlantic Millwright Inc. | 67 Beach Street | Malden, MA  02148 | [PHONE] |  | [EMAIL] | [NAME]
Boston Welding and Design | 7 Micro Drive | Woburn, MA 01801 | [PHONE] | [PHONE] | [EMAIL]
DCB Wedling & Fabrication, Inc. | 18 Park View Rd | [NAME], MA 02149 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Flaherty Equipment Repair Corp | PO Box 95155 | Newton, Ma 02495 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Fraser Engineering Co., Inc. | 65 Court Street | Newtonville, MA  02460 | [PHONE] |  | [EMAIL]
Needham Certified Welding Company | PO Box 647 | [NAME], MA 02494 | [PHONE] | [PHONE] | [EMAIL]
Projectdog | 18 Graf Rd, Unit 8 | Newburyport, MA 01950 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Shaw Welding Co. | PO Box 435 | Billerica, MA  01824 | [PHONE] |  | [EMAIL] | [NAME]
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 2Inter O&M Entry

Intermittent O&M Costs Input
Alternative:
For each component, enter "Y" in the gray area in the year in which replacement, if any, will occur.
 |  |  |  |  |  |  |  | Year O&M Needed?  (Insert Y in year where O&M is needed.)
Component | Unit Cost | Unit | Quantity | Replacement Needed? (Years 1-5) | Replacement Needed? (Years 6-10) | Replacement Needed (Years 11-15) | Replacement Needed? (Years 16-20) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Spreadsheet: 50a435ec-4609-4b19-b6a1-f0ee3c30fc51
Sheet: Complete_Newman_Reg_Report

Report for [NAME] partition of complete model with cofactors and regulatory edges present (Figure 5A)
Module_ID | Size | Cycle_Count | Homogeneity Index | Depth | Height
15900 | 159 | 1306 | 0.2658227848101266 | 0 | 2
15902 | 76 | 1053 | 0.2894736842105263 | 1 | 1
15903 | 83 | 1004 | 0.3975903614457831 | 1 | 1
15905 | 15 | 45 | 0.2666666666666667 | 2 | 0
15906 | 61 | 1019 | 0.2950819672131147 | 2 | 0
15907 | 3 | 0 | 0.6666666666666665 | 2 | 0
15908 | 10 | 45 | 0.3 | 2 | 0
15909 | 1 | 0 | 1 | 2 | 0
15910 | 1 | 0 | 1 | 2 | 0
15914 | 75 | 1053 | 0.3733333333333334 | 1 | 1
15915 | 28 | 1021 | 0.3928571428571428 | 2 | 0
15916 | 47 | 11 | 0.4680851063829787 | 2 | 0
15920 | 45 | 11 | 0.4888888888888889 | 2 | 0
15923 | 2 | 0 | 1 | 2 | 0
15924 | 7 | 0 | 0.5714285714285714 | 1 | 0
15925 | 1 | 0 | 1 | 1 | 0
Spreadsheet: 853323d1703187369-power-query-looking-at-the-previous-weeks-value-in-a-conditional-column-sample-dataset-pq
Sheet: Output

SKU ID | SKU Description | Production Site ID | Production Site Description | Week | Demand (Kg) | Closing Stock Coverage (Days) | Demand at Risk (*)
A1000 | First Sample SKU | Plant 1 | First Sample Plant | Wk50-2023 | 1226 | 21 |  |  | (*) Demand is at risk: Calculated column in power query. Logic: If the "Closing Stock Coverage" of Week x-1 is <= 3 days, then demand at risk is equal to the demand of Week x.
A1000 | First Sample SKU | Plant 1 | First Sample Plant | Wk51-2023 | 5420 | 7
A1000 | First Sample SKU | Plant 1 | First Sample Plant | Wk52-2023 | 8839 | 3
A1000 | First Sample SKU | Plant 1 | First Sample Plant | Wk01-2024 | 3868 | 19 | 8839
A1000 | First Sample SKU | Plant 1 | First Sample Plant | Wk02-2024 | 5136 | 8
[NAME] | Second Sample SKU | Plant 1 | First Sample Plant | Wk50-2023 | 7055 | 12
[NAME] | Second Sample SKU | Plant 1 | First Sample Plant | Wk51-2023 | 4439 | 10
[NAME] | Second Sample SKU | Plant 1 | First Sample Plant | Wk52-2023 | 2052 | 6
[NAME] | Second Sample SKU | Plant 1 | First Sample Plant | Wk01-2024 | 6891 | 10
[NAME] | Second Sample SKU | Plant 1 | First Sample Plant | Wk02-2024 | 4770 | 2
[NAME] | Third Sample SKU | Plant 2 | Second Sample Plant | Wk50-2023 | 7645 | 4
[NAME] | Third Sample SKU | Plant 2 | Second Sample Plant | Wk51-2023 | 5906 | 48
[NAME] | Third Sample SKU | Plant 2 | Second Sample Plant | Wk52-2023 | 1665 | 2
[NAME] | Third Sample SKU | Plant 2 | Second Sample Plant | Wk01-2024 | 3521 | 1 | 1665
[NAME] | Third Sample SKU | Plant 2 | Second Sample Plant | Wk02-2024 | 3169 | 9 | 3521
[NAME] | Fourth Sample SKU | Plant 2 | Second Sample Plant | Wk50-2023 | 9940 | 21
[NAME] | Fourth Sample SKU | Plant 2 | Second Sample Plant | Wk51-2023 | 8466 | 3
[NAME] | Fourth Sample SKU | Plant 2 | Second Sample Plant | Wk52-2023 | 3629 | 21 | 8466
[NAME] | Fourth Sample SKU | Plant 2 | Second Sample Plant | Wk01-2024 | 2608 | 14
[NAME] | Fourth Sample SKU | Plant 2 | Second Sample Plant | Wk02-2024 | 1761 | 7