tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845910d1697203565-extract-data-from-table-depending-upon-entered-cells-to-work-for-every-row-sample-for-excel-forum-electrical
Sheet: Sheet1

 |  |  | Floor | Name | ``` | Room | , [NAME] | , Pendent Light | , 5 amp Wall light | , Door controlled light | , LED Strip  Light | , Wall up/Down | ,  1 Gang Switch | , 2 Gang Switch | , 3 Gang Switch | , 4 Gang Switch | , [NAME] | , [NAME] | , PIR | , Single Socket | , Double Socket | , 5A Wall Socket | , [NAME] power | , Velux power | , Shaver  Socket | , [NAME] | , Heated Mirror | , [NAME] | , Extractor | , [NAME] | , Appliances | , Isolator | , Mesh | , Door entry | , TV Point | , Router | , [NAME] | , [NAME] | , Pressureized Sys | , [NAME] | , Thermostat | , Ethernet point
 |  | [NAME] Down Light  3 |  |  |  |  | 3 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 6 | 6
 |  | [NAME]  - LED Strip  Light 1 |  |  |  |  | 4 | 2 |  |  |  |  | 1 | 1 | 3 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 1
 |  | [NAME] Socket6 |  |  |  |  | 5 |  | 2 | 2 |  |  | 1 | 2 | 2 |  |  |  |  |  | 5 | 2
 |  | [NAME] |  |  |  |  | 5 |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 5 | 2 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1
Spreadsheet: 3c791d4c-464b-4358-b4aa-cd385ff4c7da
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
 | 5671.0 Lending Finance, Australia
 | TABLE 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413927F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 278158d1384573764-formula-to-calculate-user-fees-based-on-variable-rate-table-variable-fee-schedule
Sheet: Sheet1

 |  |  |  | Month
Min Users in Tier | [NAME] | [NAME] | Users | 9000000
0 | 1000000 | 0.4
1000001 |  | 0.3
 |  | 0.2
 | None | 0.1
 |  |  | Formula ->
 |  |  | ([NAME] should calculate to 2,100,000
Spreadsheet: 761938d1641307741-formula-to-display-data-from-another-worksheet-whenever-there-is-a-new-entry-wks1
Sheet: Sheet1

Date | Description | Category | Amount
2021-01-01 00:00:00 | Description 1 | I do not know | 115
2021-01-13 00:00:00 | Description 2 | maybe you know | 485
2021-01-28 00:00:00 | Description 3 | who knows? | 189
2021-02-26 00:00:00 | Description 4 | nobody knows | 145
2021-03-06 00:00:00 | Description 5 | God knows? | 906
2021-04-04 00:00:00 | Description 6 | CFG | 553
2021-07-15 00:00:00 | Description 7 | AFT | 854
Spreadsheet: 582519d1531921520-formulas-work-separately-but-not-combined-test
Sheet: TEST

Panel Qty | [NAME] | P4 Code | P4 Program | [NAME] | WJ | FS | SP | BP | RB | TRIM | Notes |  | OPF: |  | Job# |  | Mat'l:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IFERROR("",(IF(OR(CSV!Z3,CSV!AA3)>0,IF(OR(CSV!Z3<>90,CSV!AA3<> 90), "BRACKETS", ""),"")))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(OR(CSV!Z3,CSV!AA3)>0,IF(OR(CSV!Z3<>90,CSV!AA3<> 90),"BRACKETS", ""),"")))
Spreadsheet: 772356d1647239129-counting-days-sample
Sheet: Sheet1

No of Sheets | No of Persons | Days | Logic
120 | 2 | 2 | (30*2)+(60*2)
250 | 2
445 | 5
55 | 1
25 | 1
785 | 4
1002 | 6
4567 | 8
112 | 2
555 | 5
Spreadsheet: 152426d1335377693-how-to-track-multiple-purchases-book1
Sheet: Sheet1

 |  |  | Total |  | TOTAL | UNIT | Purchased |  | Dustin's Total Purchases |  | Jacob's Total Purchases
Item | Date Purchased | QTY | PRICE | Shipping | COST | COST | By
2LB Monofilament | 01/12/12 | 1400 | 69.3 | 11.71 |  |  | Dustin |  | ??? |  | ???
2.3mm Crimps | 01/12/12 | 2800 | 112 | 11.71 |  |  | Dustin
4 Ounce Weights | 01/12/12 | 1020 |  | 0 |  |  | [NAME]
6 Ounce Weights | 01/12/12 |  |  | 0 |  |  | [NAME]
Plastic Bags | 01/12/12 | 1000 | 48.74 | 15.26 |  |  | [NAME] |  | Total Purchases |  | Total Price |  | Unit Cost Per Item
 |  |  |  |  |  |  |  |  | 2LB Monofilament |  | Total price spent on item |  | Average Unit Cost
2LB Monofilament | 02/18/12 | 1800 | 82 | 16.81 |  |  | [NAME] |  | 2.3mm Crimps |  | Total price spent on item |  | Average Unit Cost
2.3mm Crimps | 02/18/12 | 2800 | 112 | 16.81 |  |  | [NAME] |  | 4 Ounce Weights |  | Total price spent on item |  | Average Unit Cost
4 Ounce Weights | 02/18/12 | 500 |  | 0 |  |  | [NAME] |  | 6 Ounce Weights |  | Total price spent on item |  | Average Unit Cost
6 Ounce Weights | 02/18/12 | 400 |  | 0 |  |  | [NAME] |  | Plastic Bags |  | Total price spent on item |  | Average Unit Cost
Spreadsheet: 3248ae84-de25-4699-9450-430822a3d612
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
CLZ | Test | CLZ | Clozapine, Serum | Clozapine, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.6 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Serum gel tube | CLOZAPINE Therapeutic range: >350 ng/mL  CLOZAPINE + NORCLOZAPINE Therapeutic range: >450 ng/mL | Monday through Friday | 3 days | 4 days | 1 | 80299 |  |  |  |  | New England
CLZ | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CLZ | Result | 33840 | Clozapine | Clozapine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 6896-5 | Clozapine:MCnc:Pt:Ser/Plas:Qn:
CLZ | Result | 33841 | Norclozapine | Norclozapine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 10992-6 | Norclozapine:MCnc:Pt:Ser/Plas:Qn:
CLZ | Result | 33842 | Clozapine+Norclozapine Total | Clozapine+Norclozapine Total | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 12375-2 | Clozapine+Norclozapine:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 707858d1607512930-checking-equality-with-previous-data-book1
Sheet: SANDBOX

Plate no | # | Movement
CBP817 |  | Car transfer
CBA700 |  | Repair
CRT561 |  | Repair
CRT240 |  | Personnel
CRT572 |  | Personnel
CBP817 |  | Repair
CRT291 |  | Personnel
CRT240 |  | Repair
CRT572 |  | Personnel
CRT561 |  | Personnel
CRT240 |  | After repair
CBP817 |  | Personnel
CBA700 |  | Repair
CRT561 |  | Repair
Spreadsheet: 784126d1655462784-search-between-dates-table-price
Sheet: Foglio1

 |  |  |  |  | Table price
 |  |  |  |  |  | DATE
CODE | DATE | PRICE |  |  | CODE | START | END | PRICE
AA1 | 2022-01-05 00:00:00 | 10 |  |  | AA1 | 2022-01-01 00:00:00 |  | 10
AA1 | 2022-02-15 00:00:00 | 12 |  |  | AA1 |  |  | 12
AA1 | 2022-06-06 00:00:00 | 15 |  |  | AA1 |  | 9999-01-01 00:00:00 | 15
AA2 | 2022-03-03 00:00:00 | 13 |  |  | AA2 | 2022-01-01 00:00:00 |  | 9
AA3 | 2022-01-15 00:00:00 | 6 |  |  | AA2 |  |  | 13
AA1 | 2022-05-03 00:00:00 | 15 |  |  | AA2 |  | 9999-01-01 00:00:00 | 18
AA2 | 2022-02-04 00:00:00 | 18 |  |  | AA3 | 2022-01-01 00:00:00 |  | 6
AA3 | 2022-04-25 00:00:00 | 14 |  |  | AA3 |  |  | 8
 |  |  |  |  | AA3 |  | 9999-01-01 00:00:00 | 14
Spreadsheet: 153055d1335732518-lookup-formula-excel-help
Sheet: Sheet1

 | [NAME] |  |  | 1B
 | BENSON |  |  | 1A
 | RONSON |  |  | 1B
 | THOMPSON |  |  | 1C
 | JENSON |  |  | 1C
 | PONSON |  |  | 1A
 | ROBERTSON |  |  | 1B
 | STEVENSON |  |  | 1A
 | JAMESON |  |  | 1B
 |  | 1A | 1B | 1C
Spreadsheet: 50364d1249755184-how-to-autosum-with-functions-test-sheet
Sheet: Sheet1

Order Form
 | Date:
 | Purchase Order Number:
Code | Description | Pack Size |  | Price /Unit | [NAME] | Niel | [NAME] | [NAME] | [NAME] | [NAME] | Total
TCR500 | blue centre feed (perforated) | 6 x 1 |  | 13.5 | 1 TUB | 1 TUB | 1 TUB | 1 TUB | 1 TUB | 1 TUB
SKS03050 | 25 Litre pump | 1 |  | 1.48
OPTA12/S | Air  (Automatic) | 12 x 1 |  | 45.14
TCR3690 | [NAME] | 4 x 5 litre | £1.32/kg | 26.4 | 1 BOX | 1 BOX | 3 BOX | 2 BOX | 1 BOX | 1 BOX
TCR560 | Aluminium [NAME] | 1 |  | 3.81
TCR501 | Aluminium [NAME] | 1 |  | 3.81
TCR560 | Aluminium [NAME] | 1 |  | 3.81
 |  |  | Totals
 | I would like to auto sum F5 times by E5 and the same all the way across
 | i'm trying to get a cost for each person
Spreadsheet: 108167d1305228696-int-function-misuse-book1
Sheet: Sheet1

FY TGT | Oct | Nov | Dec | 1ST QTR | Jan | Feb | Mar | 2ND QTR | Apr | May | Jun | 3RD QTR | Jul | Aug | Sep | 4TH QTR | Total |  | Achieved | POINTS
 | ACC | ACC | ACC | TOTAL | ACC | ACC | ACC | TOTAL | ACC | ACC | ACC | TOTAL | ACC | ACC | ACC | TOTAL | TGT | ACC | %
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 5 | 0.4545454545454545 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 0.5 | 0
20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 5 | 0.25 | 0
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 11 | 1 | 10
16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 17 | 1.0625 | 16
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 7 | 1 | 10
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 2 | 0.25 | 0
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 1 | 0.1111111111111111 | 0
86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86 | 50 | 0.5813953488372093
 |  |  |  |  |  |  |  |  | 11 | 5 | 0.4545454545454545
Spreadsheet: 93d2109c-74bd-405f-a4fc-7af0cc87b0c7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5835 | 44407 | Christian | Preece | GBR | 0 | 00:34:41 | 00:01:04 | 01:15:55 | 00:00:57 | 00:18:22 | 1 | [NAME]
5835 | 30640 | [NAME] | Bailey | GBR | 0 | 00:34:15 | 00:00:57 | 01:17:30 | 00:00:48 | 00:19:09 | 2 | 02:12:44
5835 | 44406 | [NAME] | Halliday | GBR | 0 | 00:34:26 | 00:00:57 | 01:17:36 | 00:00:54 | 00:22:58 | 3 | 02:16:55
5835 | 44409 | [NAME] | [NAME] | USA | 0 | 00:35:56 | 00:01:38 | 01:26:23 | 00:01:30 | 00:19:27 | 4 | 02:24:58
5835 | 44408 | [NAME] | Cooke | USA | 0 | [NAME] | 00:01:38 | 01:42:39 | 00:01:38 | 00:25:29 | 5 | 02:55:46
Spreadsheet: 750987d1633763896-how-to-combine-a-formula-to-repeat-and-get-the-number-of-times-forum-help21-10-9
Sheet: Sheet1

Job number | Name |  |  | Name | number of times
118 | B |  |  |  |  |  |  | 1 |  |  | 1
118 | B |  |  | B |  |  | B | 4 |  | B | 4
118 | B
118 | B
118 | B
161 | B
161 | B
191 | B
191 | B
191 | B
191 | B
191 | B
162 | B
162 | B
162 | B
162 | B
168 | A
168 | A
168 | A
168 | A
168 | A
168 | A
Spreadsheet: 68370d1268907395-problem-creating-an-if-formula-data-sample-for-formula-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
P1 |  | 33 |  |  |  | 12 | F5 | F4 | 1 | F4 |  |  | 2 | F5 | F4 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 10 | 0 | 0 | 85 |  | 1 | 1.000000000000001
P2 | F7 |  | 27 | F4 | 14 |  |  |  |  |  | F4 | F6 |  |  |  | F5 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | 6 | 7 | 70
P1 | F4 |  | 1 | 10 |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 47 |  | 1 | 2.000000000000002
P2 |  | 5 |  |  | 1 | 24 | F4 | F4 | F4 | 1 | F4 | F4 | F4 | F4 | F4 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 0 | 0 | 0 | 68
 | In Rows 2 and 3, I want a formula to ignore F7 in Cell B3 and find the first cell in a column which is numerical - in this example it is 33 in cell C2.
 | It should then look at the total in AJ2 and if that is greater than AJ3 it would return a Value of "1" or if it is smaller it would return a Value of "0".
 | Similarly in Rows 4 and 5, the formula needs to ignore the value of F4 in Cell B4 and find the value of 5 in cell C5. Then if AJ5 > AJ4 return "1" or "0"
 | if AJ4>AJ5.
P1 | F4 | F4 | F4 | F4 | F4 | 1 |  | 1 |  | 1 | 5 | 1 |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 0 | 0 | 0 | 66 | 1 | 1
P2 |  |  |  |  |  |  | 33 |  | 4 |  |  |  | F4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 41
P1 | F7 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 7 | 87 | 1 | 1
P2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 9206 | 10000 | 6058 | 6400
2 | 10335 | 10000 | 8049 | 6400
3 | 11989 | 10000 | 8559 | 6400
4 | 11848 | 10000 | 8872 | 6400
5 | 11419 | 10000 | 8399 | 6400
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
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  | 32454
2002-03-05 00:00:00
CBS Volume
 |  |  | -112209
Spreadsheet: 03a36e79-7f44-4d53-afab-7daedc58773a
Sheet: Sheet1

Date | Start (BST) | End (BST) | Match | Notes
2012-05-07 00:00:00 | 12:00 | 20:00 | Round 1 | Live
2012-05-08 00:00:00 | 12:00 | 20:00 | Round 1  / Round 2 | Live
2012-05-09 00:00:00 | 12:00 | 22:00 | Round 2 | Live
2012-05-10 00:00:00 | 12:00 | 22:00 | Last 16 | Live
2012-05-11 00:00:00 | 12:00 | 16:00 | Quarter Finals | Live
2012-05-11 00:00:00 | 18:00 | 22:00 | Quarter Finals | Live
2012-05-12 00:00:00 | 14:30 | 16:30 | Semi Final | Live
2012-05-12 00:00:00 | 18:00 | 20:00 | Semi Final | Live
2012-05-13 00:00:00 | 17:30 | 20:00 | Final | Live
Spreadsheet: 724430d1616157901-get-date-from-table-to-other-sheet-planning-2021-week-11b
Sheet: Info

 | Dosier N° | Column5 | Werfomschrijving | N° | ∑ PW | ∑ BA | Latei ft ≠ St. | ∏ | ꙱ | Column1 | Column2 | Column3 | G.F.⌠ | G.M.₼ | Column4 | Dat. S12 | N° lot | Dat. S32 | Leverdat. | Verbo N° | TDL-N° | Koer N° | Naar werf | Terug
 | 202000021
Spreadsheet: 4617679b-90d1-4471-b718-a50deb8f99ed
Sheet: Sheet1

Table S7. Univariate and [NAME] including the classification and other molecular annotations | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Discovery dataset | Annotation | Value | UNIVARIATE ANALYSIS |  |  |  |  |  | BEST MULTIVARIATE MODEL
 |  |  | n | n.event | [NAME] | 95%C.I. | modality | model | n | [NAME] | 95%C.I. | modality | model
 |  |  |  |  |  |  | P value | P value |  |  |  | P value | P value
 |  |  |  |  |  |  | ([NAME]) | (Log-rank) |  |  |  | ([NAME]) | (Log-rank)
 | TNM Stage | - | 359 | 103 | 1.6 | 1.1-2.4 | 0.013 | 0.0121668822561288
 | CIT classification recoded | C4C6 | 359 | 103 | 1.7 | 1.1-2.6 | 0.015 | 0.013605872878087 | 264 | 2.1 | 1.2-3.4 | 0.0061 | 0.0047
 | KRAS Mutation | M | 340 | 95 | 1.5 | 1-2.3 | 0.037 | 0.0356213158514618 |  | 1.5 | 0.95-2.5 | 0.083
 | MMR Status | MSS | 327 | 97 | 1.8 | 0.89-3.5 | 0.1 | 0.0979894668558066
 | CIT classification | C2 | 359 | 103 | 0.73 | 0.38-1.4 | 0.35 | 0.175861650070439
 |  | [NAME] |  | 103 | 1.1 | 0.54-2.3 | 0.77
 |  | C4 |  | 103 | 1.7 | 0.88-3.4 | 0.11
 |  | C5 |  | 103 | 0.95 | 0.53-1.7 | 0.85
 |  | C6 |  | 103 | 1.4 | 0.76-2.8 | 0.26
 | CIMP Status | CIMP+ | 298 | 75 | 0.7 | 0.38-1.3 | 0.26 | 0.257121550351913
 | BRAF Mutation | M | 308 | 78 | 0.75 | 0.35-1.6 | 0.47 | 0.469962168397424
 | TP53 Mutation | M | 201 | 68 | 1 | 0.63-1.7 | 0.92 | 0.923045324828122
[NAME]: [NAME], 95% C.I.: 95Percent Confidence Interval of HR. Value : modality of the annotation associated to H.R.
Spreadsheet: michelle_lokay__26576__Dec00pnr
Sheet: USGT 500622

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | USGT | 27268 | 00/12 | 500622 | PnR
1 |  |  |  |  |  |  | -68 |  |  |  | 0.05 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
3 |  |  |  |  |  | 68 |  |  |  |  | 0.05 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
5 |  |  |  |  |  |  | -2331 |  |  |  | 0.05 | 0.3883
6 |  |  |  |  |  | 2331 |  |  |  |  | 0.05 | 0.3883
7 |  |  |  |  |  | 11152 |  |  |  |  | 0.05 | 0.3883
8 |  | Note: RIDE NOT AVAILABLE |  |  |  |  |  |  |  |  | 0 | 0.3883
9 |  |  |  |  |  |  | -3314 |  |  |  | 0.05 | 0.3883
10 |  |  |  |  |  |  | -1656 |  |  |  | 0.05 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
13 |  |  |  |  |  |  | -22030 |  |  |  | 0.05 | 0.3883
14 |  |  |  |  |  | 10964 |  |  |  |  | 0.05 | 0.3883
15 |  |  |  |  |  | 54884 |  |  |  |  | 0.383 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
17 |  |  |  |  |  |  | -10133 |  |  |  | 0.383 | 0.3883
18 |  |  |  |  |  | 125 | -32745 |  |  |  | 0.383 | 0.3883
19 |  |  |  |  |  | 11523 |  |  |  |  | 0.383 | 0.3883
20 |  |  |  |  |  | 29940 |  |  |  |  | 0.383 | 0.3883
21 |  |  |  |  |  |  | -13069 |  |  |  | 0.383 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.383 | 0.3883
24 |  |  |  |  |  |  | -2412 |  |  |  | 0.383 | 0.3883
25 |  |  |  |  |  |  | -7229 |  |  |  | 0.383 | 0.3883
26 |  |  |  |  |  |  | -6970 |  |  |  | 0.383 | 0.3883
27 |  |  |  |  |  |  | -5208 |  |  |  | 0.383 | 0.3883
28 |  |  |  |  |  |  | -6343 |  |  |  | 0.383 | 0.3883
29 |  |  |  |  |  |  | -4215 |  |  |  | 0.383 | 0.3883
30 |  |  |  |  |  |  | -3264 |  |  |  | 0.383 | 0.3883
31 |  |  |  |  |  |  | 0 | 0 |  |  | 0.383 | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 729407d1619076393-subtract-2nd-to-last-non-zero-value-in-column-from-last-entered-value-in-same-column-h2ocount_dom
Sheet: Sheet1

 |  |  |  |  | MAIN |  |  | DOM.
 |  |  |  |  | DATE | M3/KL | USED | M3/KL | USED
 |  |  |  |  | 2020-10-01 00:00:00 | 62843 |  | 110064
 |  |  |  |  | 2021-01-15 00:00:00 | 62846
 |  |  |  |  | 2021-01-27 00:00:00 | 62913 |  | 110176
 |  |  |  |  | 2021-01-30 00:00:00 | 63007
 |  |  |  |  | 2021-01-31 00:00:00 | 63187
 |  |  |  |  | 2021-02-01 00:00:00 | 63283
 |  |  |  |  | 2021-02-02 00:00:00 | 63466
 |  |  |  |  | 2021-02-03 00:00:00 | 63557
 |  |  |  |  | 2021-02-04 00:00:00 | 63667
 |  |  |  |  | 2021-02-09 00:00:00 | 63772
 |  |  |  |  | 2021-02-10 00:00:00 | 63818
 |  |  |  |  | 2021-02-15 00:00:00 | 63870
 |  |  |  |  | 2021-02-17 00:00:00 | 64130 |  | 110199
 |  |  |  |  | 2021-02-19 00:00:00 | 64395 |  | 110219
 |  |  |  |  | 2021-02-22 00:00:00 | 64522 |  | 110219
 |  |  |  |  | 2021-02-25 00:00:00 | 64762 |  | 110254
 |  |  |  |  | 2021-02-27 00:00:00 | 64967
 |  |  |  |  | 2021-03-09 00:00:00 | 65597 |  | 110294
 |  |  |  |  | 2021-03-29 00:00:00 | 66177
 |  |  |  |  | 2021-03-31 00:00:00 | 66435
 |  |  |  |  | 2021-04-01 00:00:00 | 66685
 |  |  |  |  | 2021-04-06 00:00:00 | 66979 |  | 110333
 |  |  |  |  | 2021-04-08 00:00:00 | 67467
 |  |  |  |  | 2021-04-12 00:00:00 | 67940
Spreadsheet: 857257d1706280083-how-to-add-the-results-of-2-entries-into-the-same-cell-staffing-predictor-aligw
Sheet: DRAFT

 |  |  | [NAME] |  | Room | Plug Date | Trigger Date | MFS #1 | 1st Touch | MFS #2 | 2nd Touch | MFS #3 | 3rd Touch | MFS #4 | Final Defol
 |  |  |  |  | 1 |  |  |  | 2023-12-13 00:00:00
 |  |  |  |  | # of people
 |  |  |  |  | 2
 |  |  |  |  | # of people
 |  |  |  |  | 3
 |  |  |  |  | # of people
 |  |  |  |  | 4
 |  |  |  |  | # of people
 |  |  |  |  | 5
 |  |  |  |  | # of people
 |  |  |  |  | 6
 |  |  |  |  | # of people
 |  |  |  |  | 7
 |  |  |  |  | # of people
 |  |  |  |  | 8
 |  |  |  |  | # of people
 |  |  |  |  | 9
 |  |  |  |  | # of people
 |  |  |  |  | 10
 |  |  |  |  | # of people
 |  |  |  |  | 11
 |  |  |  |  | # of people
 |  |  |  |  | 12
 |  |  |  |  | # of people
 |  |  |  |  | 13
 |  |  |  |  | # of people
 |  |  |  |  | 14
 |  |  |  |  | # of people
 |  |  |  |  | 15
 |  |  |  |  | # of people
 |  |  |  |  | 16
 |  |  |  |  | # of people
 |  |  |  |  | 17
 |  |  |  |  | # of people
Spreadsheet: 130517d1322409595-copy-non-blank-cells-to-seperate-sheets-with-the-relevant-headings-epoxy-colors-new
Sheet: Sheet1

 |  |  | Description | Prod Code | Number of Mono | Stock | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | Item 11 | Item 12 | Item 13 | Item 14 | Item 15 | Item 16 | Item 17 | Item 18 | Item 19 | Item 20 | Item 21 | Item 22
 |  |  | Green | 123 | 3 | Yes | 79.4 | 14.6 |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  | Blue | 321 | 4 | Yes | 99.36 | 0.33 |  | 0.28 |  |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  | Red | 212 | 5 | Yes | 10.3 | 7.4 |  |  |  |  | 76.3 |  |  |  |  | 1.9 |  |  |  |  | 4.1 |  |  |  |  |  | 100