tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862237d1709984065-index-match-multiple-criteria-if-function-book-1
Sheet: Sheet1

Person | Date | Var 1 | Var 2 | Var 3
IM | 2022-09-27 00:00:00
LD | 2022-09-27 00:00:00
IM | 2022-11-21 00:00:00 | 48 | 373 | 7.77
MB | 2022-11-24 00:00:00
JB | 2022-11-28 00:00:00 | 77.9
IM | 2022-12-22 00:00:00
JT | 2022-12-22 00:00:00
WC | 2022-12-22 00:00:00
CM | 2023-02-28 00:00:00
IM | 2023-02-28 00:00:00
JT | 2023-02-28 00:00:00
LD | 2023-02-28 00:00:00
MB | 2023-02-28 00:00:00
WC | 2023-02-28 00:00:00 |  |  |  |  | Criteria:
IM | 2023-03-03 00:00:00 | 47.2 | 438 | 9.28 |  | Return the most recent 'Var 2' value, for a particular 'Person' that is above 0 or has an entry
IM | 2023-03-07 00:00:00 |  |  | `
JT | 2023-03-07 00:00:00
LD | 2023-03-07 00:00:00 | 51.2 |  |  |  | Person | IM
TK | 2023-05-09 00:00:00 | 69 | 1201 | 17.41 |  | Var 2
IM | 2023-05-22 00:00:00
LD | 2023-05-22 00:00:00
CM | 2023-06-06 00:00:00
DF | 2023-06-06 00:00:00
JB | 2023-06-06 00:00:00
LR | 2023-06-06 00:00:00
TK | 2023-06-06 00:00:00 |  |  |  |  | Var 2
WC | 2023-06-06 00:00:00
TK | 2023-06-08 00:00:00
WC | 2023-06-08 00:00:00
WC | 2023-07-06 00:00:00
TK | 2023-07-19 00:00:00 | 68
IM | 2023-08-08 00:00:00
LD | 2023-08-08 00:00:00
TK | 2023-08-08 00:00:00
IM | 2023-10-19 00:00:00
JT | 2023-10-19 00:00:00
LD | 2023-10-19 00:00:00
SC | 2023-10-19 00:00:00
IM | 2023-10-23 00:00:00 | 50.3 | 400 | 7.95
LD | 2023-10-23 00:00:00 | 53.1 | 408 | 7.68
CM | 2024-02-16 00:00:00
JT | 2024-02-16 00:00:00
LD | 2024-02-16 00:00:00
MB | 2024-02-16 00:00:00
RH | 2024-02-16 00:00:00
SC | 2024-02-16 00:00:00
WC | 2024-02-16 00:00:00
JT | 2024-02-21 00:00:00 | 68 | 644 | 9.04
LD | 2024-02-21 00:00:00 | 51.2 | 443 | 8.65
CM | 2024-03-01 00:00:00
Cmessage | 2024-03-01 00:00:00
IM | 2024-03-01 00:00:00
JT | 2024-03-01 00:00:00
LD | 2024-03-01 00:00:00
MB | 2024-03-01 00:00:00
RH | 2024-03-01 00:00:00
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 9d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 484736 | 425351 | 962038 | 405800
OTHER* | 57251 | 420321 | 29930 | 229108
TOTAL | 541987 | 845672 | 991968 | 634908
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, FRA, Fixed-Fixed, Inflation, OIS, and Swaption.
Spreadsheet: 182868d1348644252-how-to-put-info-form-one-worksheet-ot-next-worksheet-test
Sheet: Date

[NAME]
PERSONNEL NO: |  |  | 121212 |  |  |  | NAME: | [NAME] |  |  |  |  |  | CENTRE: | Q11
GRADE-ID: |  | 1111 |  |  |  |  |  |  |  |  |  |  | OFFICIAL HOURS: |  | 45
GRADE DESCRIPTION: |  |  | Systems Administrator
PAYMASTER: |  |  |  |  |  |  |  |  |  |  |  | PAY PERIOD: |  | 2012-09-01 00:00:00
Date | Day | Desc. | On | Off | On | Off | Lost | Overtime | Sunday | PPH | Nightwork | Standby | OS | Code | Code | Acting | LEVEL
 |  |  |  |  |  |  | Time | Hours | Time | Hours | Hours | Shifts | Time |  |  | GR.
 |  |  |  |  |  |  |  |  |  |  |  |  | Auth. |  |  | GRP
2012-09-01 00:00:00 | Saturday | TI |  |  |  |  |  |  |  |  |  | 1
2012-09-02 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  | 1
2012-09-03 00:00:00 | Monday | X
2012-09-04 00:00:00 | Tuesday | X
2012-09-05 00:00:00 | Wednesday | X
2012-09-06 00:00:00 | Thursday | X
2012-09-07 00:00:00 | Friday | X
2012-09-08 00:00:00 | Saturday | TI
2012-09-09 00:00:00 | Sunday
2012-09-10 00:00:00 | Monday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-11 00:00:00 | Tuesday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-12 00:00:00 | Wednesday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-13 00:00:00 | Thursday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-14 00:00:00 | Friday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-15 00:00:00 | Saturday | TI | 09:00:00 | 16:00:00 |  |  |  | 07:00:00 |  |  |  | 1
2012-09-16 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  | 1
2012-09-17 00:00:00 | Monday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-18 00:00:00 | Tuesday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-19 00:00:00 | Wednesday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-20 00:00:00 | Thursday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-21 00:00:00 | Friday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-22 00:00:00 | Saturday | TI |  |  |  |  |  |  |  |  |  | 1
2012-09-23 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  | 1
2012-09-24 00:00:00 | Monday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-25 00:00:00 | Tuesday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-26 00:00:00 | Wednesday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-27 00:00:00 | Thursday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-28 00:00:00 | Friday | X |  |  |  |  |  |  |  |  |  | 1
2012-09-29 00:00:00 | Saturday | TI |  |  |  |  |  |  |  |  |  | 1
2012-09-30 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  | 1
TOTAL: |  |  |  |  |  |  |  | 07:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 23
HOURS OF DUTY |  |  |  |  | FROM |  | TO |  | FROM |  | TO |  | REMARKS
Monday - Friday
Saturday
I Certify the the time shown is a true |  |  |  |  | I Have examined the register and I am satisfied that the time
statement of my actual time worked |  |  |  |  | claimed is correct
 |  |  |  |  |  |  |  |  |  |  |  |  | Checked
 |  |  | 2012-09-26 09:18:05 |  | …………………………………….. |  |  |  |  | 2012-09-26 09:18:05 |  |  | ……………………………………………………………………………….
Signature |  |  | Date |  | Supervising Officer |  |  |  |  | Date |  |  | Administrative Office
Spreadsheet: 146389d1332166967-change-color-of-a-cell-based-on-two-variables-examplebook
Sheet: Sheet1

 |  |  | Completion | Due Date | Completion | Due Date | Completion | Due Date
 |  | Stage 1 | 0.75 | 2012-03-16 00:00:00 | 0.9 | 2012-03-21 00:00:00 | 0.65 | 2012-03-21 00:00:00
 |  | Stage 2 | 0.5 | 2012-03-23 00:00:00 | 0.54 | 2012-04-05 00:00:00 | 0.25 | 2012-04-02 00:00:00
 |  | Stage 3 | 0.2 | 2012-04-15 00:00:00 | 0.25 | 2012-04-09 00:00:00 | 0 | 2012-05-05 00:00:00
 |  | Stage 4 | 0 | 2012-05-05 00:00:00 | 0 | 2012-06-08 00:00:00 | 0 | 2012-06-04 00:00:00
 |  | Stage 5 | 0 | 2012-06-06 00:00:00 | 0 | 2012-06-14 00:00:00 | 0 | 2012-06-15 00:00:00
 |  |  | Product A |  | Product B |  | Product C
Spreadsheet: 2e503872-3fd4-4794-8ec5-a04b65f687cc
Sheet: IDT

 |  |  | TENNESSEE TECHNOLOGICAL UNIVERSITY |  |  |  | Page 1 of __1___
 |  |  | INTERDEPARTMENTAL TRANSFER |  |  |  |  |  |  | IDT
 |  |  |  |  |  |  |  |  |  | Date
DEBIT ACCOUNT |  |  |  | [NAME] |  |  | CREDIT ACCOUNT
ACCOUNT NAME |  | CHART/INDEX/FOAPA |  |  |  |  | CHART/INDEX/FOAPA |  |  |  | ACCOUNT NAME
 |  | COAS |  |  |  |  | COAS
 |  | Index |  |  |  |  | Index
 |  | Fund |  |  |  |  | Fund
 |  | Organization |  |  |  |  | Organization
 |  | Account Code |  |  |  |  | Account Code
 |  | Program |  |  |  |  | Program
 |  | Activity |  |  |  |  | Activity
Quantity | Description |  |  |  |  |  |  | Unit Cost |  |  | Extended Cost
 |  |  |  |  |  |  |  | SUBTOTAL
 |  |  | APPROVALS |  |  |  |  | DISCOUNT/TAX
CHARGE APPROVED _________________________ |  |  |  | Business Office  ___________________________ |  |  |  | TOTAL
CREDIT APPROVED __________________________
PREPARED BY ______________________________ |  |  |  |  | White-Business Office Accounting
 |  |  |  |  | Yellow-Business Office Duplicate
 |  |  |  |  | Blue-Department Credited
Spreadsheet: 156057d1337165577-macro-to-transpose-data-in-database-format-sample
Sheet: Required Output

50 | 21 | 21.6
50 | 21.5 | 22.1
50 | 22 | 22.6
50 | 22.5 | 23.1
50 | 23 | 23.6
50 | 23.5 | 24.1
50 | 24 | 24.6
50 | 24.5 | 25.1
50 | 25 | 25.6
50.5 | 21 | 21.6
50.5 | 21.5 | 22.1
50.5 | 22 | 22.6
50.5 | 22.5 | 23.1
50.5 | 23 | 23.6
50.5 | 23.5 | 24.1
50.5 | 24 | 24.6
50.5 | 24.5 | 25.1
50.5 | 25 | 25.6
51 | 21 | 21.5
51 | 21.5 | 22
51 | 22 | 22.5
51 | 22.5 | 23
51 | 23 | 23.6
51 | 23.5 | 24.1
51 | 24 | 24.6
51 | 24.5 | 25.1
51 | 25 | 25.6
51.5 | 21 | 21.5
51.5 | 21.5 | 22
51.5 | 22 | 22.5
51.5 | 22.5 | 23
51.5 | 23 | 23.5
51.5 | 23.5 | 24
51.5 | 24 | 24.5
51.5 | 24.5 | 25
51.5 | 25 | 25.5
52 | 21.5 | 22
52 | 22 | 22.5
52 | 22.5 | 23
52 | 23 | 23.5
52 | 23.5 | 24
52 | 24 | 24.5
52 | 24.5 | 25
52 | 25 | 25.5
Spreadsheet: 2481179a-d62c-40f3-9b2a-a5c81e31c1c4
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
MTHFR | Test | MTHFR | 5,10-Methylenetetrahydrofolate Reductase C677T, Mutation, Blood | MTHFR C677T Mutation Analysis, B | Direct Mutation Analysis | Yellow-Top (ACD) Tube: ACD |  |  | 6 | mL | Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: Lavender top (EDTA) or blue top (sodium citrate) [NAME]: Full tube Collection Instructions:  1. Invert several times to mix blood.  2. Send specimen in original tube. Additional Information: Can be combined with other molecular coagulation tests: -61730/MTHAC 5,10-Methylenetetrahydrofolate Reductase A1298C, Mutation, Blood -81419/F5DNA Factor V Leiden (R506Q) Mutation, Blood -81742/PTNT Prothrombin G20210A Mutation, Blood -61367/MTHP 5,10-Methylenetetrahydrofolate Reductase C677T and A1298C Mutations, Blood Forms: 1. Coagulation Patient Information Sheet (Supply T675) is available in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL in a 3-mL ACD tube | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK-phone lab Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Green top (heparin) tube or Extracted DNA | Negative | Monday through Friday; 12 p.m. | 3 days | 5 days | 1 | 81291 |  |  |  |  | Rochester
MTHFR | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 7 days
MTHFR | Result | 21827 | [NAME], B | [NAME], B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21709-1 | MTHFR gene mutation analysis:Prid:Pt:Bld/Tiss:Nom:Molgen
MTHFR | Result | 21828 | MTHFR Interpretation | MTHFR Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
MTHFR | Result | 21830 | MTHFR Reviewed By | MTHFR Reviewed By | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 810576d1671861957-skins-formula-for-a-golf-game-skins-problem-hd
Sheet: Sheet1

 | Team | Player | Hole  1 | Hole  2 | Hole  3 | Hole  4 | Hole  5 | Hole  6 | Hole  7 | Hole  8 | Hole  9 | Hole  10 | Hole  11 | Hole  12 | Hole  13 | Hole  14 | Hole  15 | Hole  16 | Hole  17 | Hole  18 | Front | Back | Total | Front      6 | Middle 6 | Back      6 | Skins
 | A | a | 5 | 4 | 5 | 3 | 6 | 2 | 6 | 4 | 6 | 3 | 5 | 4 | 6 | 3 | 7 | 4 | 5 | 7 |  |  |  |  |  |  |  |  |  | Need a formula in AB3 down to AB28
 | A | b | 4 | 5 | 6 | 7 | 3 | 7 | 7 | 6 | 4 | 7 | 5 | 7 | 5 | 6 | 6 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  | Showing how many skins each player received.
 | K | c | 5 | 4 | 5 | 6 | 3 | 6 | 7 | 4 | 4 | 6 | 6 | 4 | 6 | 4 | 7 | 7 | 6 | 5 |  |  |  |  |  |  |  |  |  | I've manually put in the correct answers
 | K | d | 3 | 7 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 6 | 6 | 7 | 7 | 4 | 6
 | Q | e | 4 | 7 | 6 | 5 | 6 | 5 | 5 | 4 | 6 | 5 | 6 | 6 | 7 | 7 | 3 | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  | I'd like a formula that doesn't need helper columns.
 | Q | f | 7 | 6 | 5 | 7 | 6 | 6 | 5 | 6 | 7 | 6 | 6 | 7 | 6 | 7 | 7 | 6 | 5 | 5
 | J | g | 4 | 6 | 5 | 7 | 7 | 4 | 2 | 5 | 4 | 7 | 6 | 6 | 4 | 4 | 7 | 6 | 5 | 7
 | J | h | 5 | 6 | 5 | 6 | 7 | 5 | 6 | 6 | 5 | 6 | 7 | 7 | 7 | 7 | 5 | 7 | 5 | 6
 | 10 | i | 5 | 5 | 5 | 6 | 4 | 5 | 5 | 7 | 5 | 6 | 6 | 4 | 5 | 4 | 6 | 6 | 5 | 4
 | 10 | J | 4 | 6 | 4 | 5 | 4 | 4 | 4 | 5 | 6 | 5 | 7 | 6 | 6 | 5 | 6 | 6 | 4 | 5
 | 9 | k | 5 | 6 | 5 | 5 | 7 | 6 | 4 | 5 | 5 | 5 | 4 | 6 | 4 | 5 | 7 | 6 | 4 | 7
 | 9 | l | 4 | 4 | 5 | 6 | 4 | 6 | 4 | 6 | 5 | 5 | 5 | 4 | 5 | 6 | 5 | 4 | 7 | 6
 | 8 | m | 5 | 4 | 4 | 6 | 6 | 6 | 4 | 5 | 5 | 6 | 3 | 6 | 5 | 4 | 4 | 3 | 5 | 5
 | 8 | n | 4 | 4 | 6 | 5 | 4 | 6 | 7 | 7 | 4 | 6 | 5 | 7 | 4 | 5 | 5 | 7 | 4 | 4
 | 7 | o | 4 | 6 | 7 | 5 | 6 | 7 | 7 | 5 | 7 | 5 | 5 | 5 | 7 | 6 | 7 | 6 | 6 | 5
 | 7 | p | 5 | 5 | 5 | 4 | 4 | 5 | 7 | 7 | 7 | 6 | 4 | 6 | 7 | 6 | 4 | 7 | 7 | 5
 | 6 | q | 7 | 5 | 7 | 6 | 6 | 4 | 5 | 7 | 4 | 5 | 4 | 7 | 4 | 7 | 6 | 7 | 6 | 5
 | 6 | r | 4 | 4 | 7 | 5 | 4 | 6 | 4 | 5 | 4 | 6 | 7 | 7 | 7 | 6 | 6 | 7 | 6 | 5
 | 5 | s | 4 | 6 | 6 | 7 | 4 | 4 | 4 | 4 | 5 | 7 | 5 | 7 | 4 | 5 | 4 | 7 | 6 | 4
 | 5 | t | 5 | 6 | 7 | 6 | 5 | 7 | 5 | 6 | 5 | 6 | 5 | 4 | 4 | 4 | 6 | 4 | 4 | 6
 | 4 | u | 5 | 5 | 5 | 7 | 6 | 7 | 4 | 6 | 5 | 4 | 6 | 5 | 4 | 4 | 4 | 5 | 5 | 3
 | 4 | v | 6 | 4 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 6 | 4 | 5 | 7 | 7 | 4 | 4 | 5 | 6
 | 3 | w | 5 | 5 | 6 | 6 | 7 | 7 | 6 | 7 | 4 | 5 | 4 | 5 | 7 | 7 | 7 | 5 | 4 | 4
 | 3 | x | 6 | 5 | 5 | 6 | 4 | 6 | 5 | 6 | 5 | 5 | 6 | 4 | 6 | 4 | 4 | 5 | 7 | 6
 | 2 | y | 6 | 6 | 4 | 4 | 6 | 7 | 7 | 7 | 7 | 6 | 6 | 4 | 4 | 7 | 6 | 7 | 5 | 4
 | 2 | z | 7 | 7 | 5 | 5 | 4 | 4 | 4 | 6 | 5 | 5 | 4 | 6 | 5 | 7 | 6 | 7 | 6 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | Min
 |  | Min Count |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | << Total Skins
Spreadsheet: 103635d1301384189-financial-calendar-formula-financial-calendar-formula
Sheet: Sheet1

 | 2011-01-03 00:00:00
 | 2011-01-10 00:00:00
 | 2011-01-17 00:00:00
 | 2011-01-24 00:00:00
 | 2011-01-31 00:00:00 | February
 | 2011-02-07 00:00:00
 | 2011-02-14 00:00:00
 | 2011-02-21 00:00:00
 | 2011-02-28 00:00:00 | March
 | 2011-03-07 00:00:00
 | 2011-03-14 00:00:00
 | 2011-03-21 00:00:00
 | 2011-03-28 00:00:00
 | 2011-04-04 00:00:00
 | 2011-04-11 00:00:00
 | 2011-04-18 00:00:00
 | 2011-04-25 00:00:00
 | 2011-05-02 00:00:00
 | 2011-05-09 00:00:00
 | 2011-05-16 00:00:00
 | 2011-05-23 00:00:00
 | 2011-05-30 00:00:00 | June
 | 2011-06-06 00:00:00
 | 2011-06-13 00:00:00
 | 2011-06-20 00:00:00
 | 2011-06-27 00:00:00
 | 2011-07-04 00:00:00
 | 2011-07-11 00:00:00
 | 2011-07-18 00:00:00
 | 2011-07-25 00:00:00
 | 2011-08-01 00:00:00
 | 2011-08-08 00:00:00
 | 2011-08-15 00:00:00
 | 2011-08-22 00:00:00
 | 2011-08-29 00:00:00 | September
 | 2011-09-05 00:00:00
 | 2011-09-12 00:00:00
 | 2011-09-19 00:00:00
 | 2011-09-26 00:00:00
 | 2011-10-03 00:00:00
 | 2011-10-10 00:00:00
 | 2011-10-17 00:00:00
 | 2011-10-24 00:00:00
 | 2011-10-31 00:00:00 | November
 | 2011-11-07 00:00:00
 | 2011-11-14 00:00:00
 | 2011-11-21 00:00:00
 | 2011-11-28 00:00:00 | December
 | 2011-12-05 00:00:00
 | 2011-12-12 00:00:00
 | 2011-12-19 00:00:00
 | 2011-12-26 00:00:00
Spreadsheet: 830397d1684888608-roster-management-looking-for-table-to-identify-gaps-in-roster-across-24-hour-period-rn-24-7-coverage-2-
Sheet: Table

 |  | Location | Reporting Period 6/3/23-22/3/23
 |  | Maclean
 |  | Redhead | 1
 |  | [NAME] | 0.94
 |  | [NAME] | 1
 |  | Casino | 0.87
 |  | Location | Total Available Hours | RN Delivered Hours
 |  | Maclean | 408 | 374
 |  | Redhead | 408 | 408
 |  | [NAME] | 408 | 382
 |  | [NAME] | 408 | 408
 |  | Casino | 408 | 355
Spreadsheet: 377407d1423969896-find-unique-values-from-a-range-using-formula-unique-list-from-an-array
Sheet: Sheet1

 | M | T | W | Th | F | S | S |  |  |  | Array, no helper...
A | 7 | 1 | 2 | 1 | 4 | 1 | 0
B | 3 | 4 | 3 | 1 | 0 | 2 | 0
C | 7 | 3 | 1 | 1 | 0 | 5 | 1
Spreadsheet: jeff_dasovich__14102__Patten Case Q2
Sheet: Sheet1

[NAME]
1986 Original Income Statement |  |  |  |  |  | 1986 Modified Statement |  | Difference
Revenue
 | Sale of realestate |  |  | 33262613 |  |  |  |  |  | *Total sale less total due from note 2
 | Interest Income |  |  | 1693923
Cost and Expenses
 | Cost of Real Est Sold |  |  | 15028396 |  |  |  |  |  | *Same ratio of cost/sales was used
 | Selling/Administrative Expenses |  |  | 10258788
 | Interest Expense |  |  | 1011513
 | Income from operations |  |  | 8657839
 | Other Income |  |  | 151847
 | Income before taxes/minority int |  |  | 8809686
 | Provision for income taxes |  |  | 4184086 |  |  |  |  |  | *Provision is calculated based on installments - the same in both cases
 | Income before minority interests
 | Minority interests |  |  | 674786
 | Net Income
 | Net Income per share |  |  | 1.4
 | Weighted ave shares |  |  | 2829303
 |  |  |  |  |  | From Note 2: Intallments due on notes receivable
 |  |  |  |  |  | March 31 1987 |  |  |  | 1328374
 |  |  |  |  |  | March 31 1988 |  |  |  | 1412710
 |  |  |  |  |  | March 31 1989 |  |  |  | 1504613
 |  |  |  |  |  | March 31 1990 |  |  |  | 1491521
 |  |  |  |  |  | March 31 1991 |  |  |  | 1462209
 |  |  |  |  |  | Thereafter |  |  |  | 11363435
 |  |  |  |  |  | Total
Spreadsheet: 844944d1696534139-need-help-with-a-date-and-time-off-calculation-formula-two-parts-book3
Sheet: VACATION CHART

N O T E: * Designates ONE WEEK is earned AFTER anniversary date
 |  |  | Seniority [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Follow company/department policies:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S = [NAME] week(s)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H = Half-Day week(s)
 | S61KM-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y = Buy back week(s)
LM # | Employee Name | Vac Date |  | [NAME] | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | H | Y
 | NBR OF EMPLOYEES PICKED
 | PERCENT PICKED
 | MAX PERCENT ALLOWED |  |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
 | MAX EMPLOYEES ALLOWED
Spreadsheet: 789462d1659105357-hlook-up-not-working-last-man-standing
Sheet: Week 2

 | Week 2
 | NAME | TEAM
Spreadsheet: 39837d1238100025-how-much-time-for-concrete-truck-concretetimes
Sheet: TrackingSheet

Truck | Date | Concrete | AddMix1 | AddMix2 | AddMix3 | AddMix4 | Time Mixed | Base Time | AddMix | Pour By
Truck1 | 2009-03-15 00:00:00 | Class A | mix3 | mix4 |  |  | 10:00:00 | 11:30:00 | 10 | 11:40:00
Truck2 | 2009-03-16 00:00:00 | Minor Structure | [NAME] | mix13 |  |  | 09:30:00 | 10:30:00 | -10 | 10:20:00
Spreadsheet: 747886d1631759419-if-cell-contains-multiple-values-then-show-same-in-help-copy
Sheet: PRINT REVIEW

 | Nowergup Depot
 | Month |  |  | June |  |  |  | July
 |  | Printed |  | cycle 415 |  |  |  |  |  |  | cycle 416
 | Weekending |  |  | 2022-07-03 00:00:00 |  |  |  |  |  |  | 2022-07-10 00:00:00
 | Date |  |  | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | Day |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S
 | Surname | Name | Serv # | On 2021-2022 Roster
 | Driver Coordinators
1 | [NAME]
2 | [NAME]
3 | [NAME]
 | DC's to cover
 | Driver Trainers | Name | Serv #
1
2
3
4
5
6
7
8
9
 | Driver | Name | Serv #
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
 | Leave
 | Training
 | DC coverage
 | Alter Duties
 | Job share / part time
 | Lines to cover
 | Lines available
 | Depot Masters to cover |  |  | Cycle 549 |  |  |  |  |  | Cycle 550 |  |  |  |  |  |  | Cycle 551 |  |  |  |  |  |  | Cycle 552
Spreadsheet: 1efcfd69-c074-472a-ae52-519e0eabac18
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
7557 | 15194 | Sergey | Mishanin | RUS | 113 | 00:15:42 | 00:00:36 | 00:18:13 | 00:00:48 | 00:16:01 | 1 | 00:51:25
7557 | 10402 | Martin | Flinta | SWE | 116 | 00:15:42 | [NAME] | 00:19:11 | 00:00:56 | 00:17:52 | 2 | 00:54:25
7557 | 46346 | Miika | Osmo | FIN | 111 | 00:16:15 | 00:00:44 | 00:20:44 | 00:01:16 | 00:18:32 | 3 | 00:57:36
7557 | 46380 | [NAME] | Vilppola | FIN | 112 | 00:15:44 | 00:00:36 | 00:24:48 | 00:00:54 | 00:17:03 | 4 | 00:59:11
7557 | 46437 | [NAME] | Borremans | BEL | 115 | 00:16:13 | 00:00:43 | 00:23:52 | 00:01:20 | 00:19:26 | 5 | [NAME]
7557 | 56577 | [NAME] | [NAME] | RUS | 114 | 00:17:24 | 00:00:29 | [NAME] | 00:01:04 | 00:16:55 | 6 | 01:04:32
Spreadsheet: 714512d1611250754-help-computing-a-running-total-between-2-sheets-book6
Sheet: Sheet1

 |  | Date |  | Incoming Weight
PO | Line | 2020-01-25 00:00:00 | 10:00:00 | 45000 | Status
PO | Line | 2020-01-25 00:00:00 | 15:00:00 | 45000 | Status
PO | Line | 2020-01-26 00:00:00 | 10:00:00 | 45000 | Status
PO | Line | 2020-01-26 00:00:00 | 15:00:00 | 45000 | Status
PO | Line | 2020-01-26 00:00:00 | 15:00:00 | 0 | Status
PO | Line | 2020-01-27 00:00:00 | 10:00:00 | 45000 | Status
PO | Line | 2020-01-27 00:00:00 | 15:00:00 | 45000 | Status
PO | Line | 2020-01-28 00:00:00 | 10:00:00 | 45000 | Status
PO | Line | 2020-01-28 00:00:00 | 15:00:00 | 45000 | Status
PO | Line | 2020-01-29 00:00:00 | 10:00:00 | 45000 | Status
PO | Line | 2020-01-29 00:00:00 | 15:00:00 | 45000 | Status
PO | Line | 2020-01-30 00:00:00 | 10:00:00 | 45000 | Status
PO | Line | 2020-01-30 00:00:00 | 15:00:00 | 45000 | Status
PO | Line | 2020-01-31 00:00:00 | 10:00:00 | 45000 | Status
This is the schedule, I assume some sort of VLOOKUP formula needs to be done utilizing Columns C and E
I want to take the incoming weight, and have it added to the running total on the previous sheet
Example: The previous sheet shows a starting of 200,000. Then on Monday we are using a total of 82,204 between both production lines; but on Monday we also have an incoming qty of 90,000
(See Rows 4 and 5)
How can I set up the VLOOKUP to add the weight on the 1st page based on the dates and qtys on the 2nd?