tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19041__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-06 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-05 00:00:00 |  | 224.86 | 22592 | 122.93 | 16784
 | 2001-04-04 00:00:00 |  | 237.5 | 23824 | 129.77 | 12120
 | 2001-04-03 00:00:00 |  | 232.96 | 14960 | 120.77 | 12904
 | 2001-04-02 00:00:00 |  | 224.92 | 23056 | 133.39 | 11728
 | 2001-04-01 00:00:00 |  |  |  |  |  | 133.75 | 35784
 | 2001-03-31 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-30 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-29 00:00:00 |  | 163.49 | 34064 | 92.05 | 9080
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
 | 2001-03-24 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-23 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
Spreadsheet: 274559d1383149380-finding-value-using-formulas-functions-or-macros-in-intersection-of-2-data-series-in-graph-964962
Sheet: Hoja1

 | DATA SERIE1
 | DATA FOR BLACK  LINE
 |  |  |  |  |  |  |  |  |  |  |  |  | Intersections
 | X Axe | Y Axe
 | 76.19999999999999 | 100
 | 63.5 | 100
 | 50.8 | 100
 | 38.09999999999999 | 100
 | 25.4 | 89.27423454202909
 | 19.05 | 87.32863057523437
 | 12.5 | 82.72863057523438
 | 9.5 | 80.22863057523438
 | 4.75 | 72.02863057523437
 | 2 | 61.42863057523437
 | 0.42 | 42.42863057523437
 | 0.075 | 27.22863057523437
Repeat
last set of values
 |  |  |  |  | data for red vertical line |  |  |  |  |  |  |  | DATA SERIE 2
 |  |  | NUMBER THAT I WANT  TO FIND  AUTOMATICALLY USING FUNCTIONS  FORMULAS OR [NAME] |  |  |  | 0 | 60 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  | THIS NUMBER  IS THE X VALUE FOR WHICH THE Y VALUE FOR THE SERIE1 IS 60 |  |  | NOTE:VALUES IN X AXE IS IN INVERSE ORDER THE SCALE OF X AXE IS IN LOG BASE 10 |  |  |  |  | 100 | 60
Spreadsheet: 77216d1277736828-does-this-require-vlookup-service-dispatch-w-tabs
Sheet: LABOR

 | ASSIGNED | COMPLETED | TOTAL INCOMPLETE
LAST UPDATED: |  |  |  |  | TOTAL HOURS WORK ASSIGNED TO TECH
2010-06-28 09:48:09 |  |  |  |  |  | TOTAL HOURS OF WAITERS ASSIGNED TO TECH
(BF) FISHER, BRENT | 1 | 1 | 0 |  | 1 | 0
(BS) SCHINDEL, ROBERT | 2.5 |  | 2.5 |  | 2 | 0.5 |  |  |  |  |  |  | NOTE TO PROGRAMMERS: TEXT HIDDEN (FONT COLOR SET TO WHITE OR GRAY) AT F4:G14, [NAME]:K20, AND [NAME]:Q36. THE PURPOSE OF THESE FIELDS ARE TO PROVIDE CALCULATIONS TO BE DISPLAYED IN B4:B31 AND H18:I30.
(DA) BRATKOWSKI, DAN | 0 |  | 0 |  | 0 | 0
(DB) BILANSKY, DAN | 0 |  | 0 |  | 0 | 0
(DH) HAGEMANN, DEAN | 3.7 | 3.7 | 0 |  | 3.7 | 0
(JZ) MATYSZCZYK, JASON | 1 | 3.1 | -2.1 |  | 1 | 0
(RA) ACHTERHOF, RYAN | 7.5 | 3.8 | 3.7 |  | 6.5 | 1
(RG) GOTTFRIED, RICH | 3 | 3 | 0 |  | 3 | 0
(TF) FRITZ, TOM | 7 | 7 | 0 |  | 7 | 0
(TP) POLIZZI, [NAME] | 12.3 | 6 | 6.300000000000001 |  | 11.3 | 1
(HB) HAROUT | 0 |  | 0 |  | 0 | 0
TOTAL: | 38 | 27.6 | 10.4
 |  |  |  |  |  |  |  |  |  |  |  |  | calculations
(MH) HOLLAND, [NAME] | 0 |  | 0 |  | FUTURE | WORK | HOURS | # of JOBS | 0 | 0 |  | total hours | [NAME] | WASHED |  | TODAY
(MK) KIOSKI, [NAME] | 0 |  | 0 |  | MON: | 2010-06-28 00:00:00 | 11.9 | 5 | 0 | 0 |  | 11.9 | 0 | 0 |  | 2010-06-28 00:00:00
(RS) SLOWINSKI, RANDAL | 0 |  | 0 |  | TUE: | 2010-06-29 00:00:00 | 5.800000000000001 | 4 | 0 | 0 |  | 5.800000000000001 | 0 | 0
(AC) CLAFLIN, ANDY | 0 |  | 0 |  | WED: | 2010-06-30 00:00:00 | 8 | 2 | 0 | 0 |  | 8 | 0 | 0
TOTAL: | 0 | 0 | 0 |  | THU: | 2010-07-01 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  | FRI: | 2010-07-02 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
TOTALS: | 38 | 27.6 | 10.4 |  | SAT: | 2010-07-03 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
UNASSIGNED WORK: | 0 hrs | 0 jobs | 0 waiters |  | MON: | 2010-07-05 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  | 0 | 0 |  | TUE: | 2010-07-06 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
AVAILABLE HOURS: | 13.6 |  |  |  | WED: | 2010-07-07 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  | THU: | 2010-07-08 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
[NAME] AVAILABLE: | 3 |  |  |  | FRI: | 2010-07-09 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  | SAT: | 2010-07-10 00:00:00 | 0 | 0 |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF JOBS UNASSIGNED FOR THE CURRENT DAY
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF WAITERS LEFT UNASSIGNED
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 777005d1650060416-retain-only-rows-where-column-a-has-values-in-column-b-and-c-that-are-unique-to-value-in-a-example
Sheet: Desired Output

Login_ID | Role | user_type | Organization |  | Login_ID | Role | user_type | Organization
[NAME] | A | 1 | Crater |  | [NAME] | A | 1 | Bubble
[NAME] | B | 1 | Crater |  | [NAME] | B | 1 | Bubble
[NAME] | C | 1 | Crater |  | [NAME] | C | 1 | Bubble
[NAME] | D | 1 | Crater |  | [NAME] | D | 1 | Bubble
[NAME] | A | 2 | Crater |  | [NAME] | A | 2 | Bubble
[NAME] | B | 2 | Crater |  | [NAME] | B | 2 | Bubble
[NAME] | A | 1 | Minnesota |  | [NAME] | A | 1 | Crater
[NAME] | B | 1 | Minnesota |  | [NAME] | B | 1 | Crater
[NAME] | C | 1 | Minnesota |  | [NAME] | C | 1 | Crater
[NAME] | D | 1 | Minnesota |  | [NAME] | D | 1 | Crater
[NAME] | A | 2 | Texas |  | [NAME] | A | 2 | Crater
[NAME] | B | 2 | Texas |  | [NAME] | B | 2 | Crater
[NAME] | C | 2 | Texas |  | [NAME] | A | 1 | Valley
[NAME] | D | 2 | Texas |  | [NAME] | B | 1 | Valley
[NAME] | A | 2 | Tree |  | Scott | A | 2 | Hat
[NAME] | A | 2 | Rock |  | [NAME] | A | 1 | Minnesota
 |  |  |  |  | [NAME] | B | 1 | Minnesota
 |  |  |  |  | [NAME] | C | 1 | Minnesota
 |  |  |  |  | [NAME] | D | 1 | Minnesota
 |  |  |  |  | [NAME] | A | 2 | Texas
 |  |  |  |  | [NAME] | B | 2 | Texas
 |  |  |  |  | [NAME] | C | 2 | Texas
 |  |  |  |  | [NAME] | D | 2 | Texas
 |  |  |  |  | [NAME] | A | 2 | Tree
 |  |  |  |  | [NAME] | A | 2 | Rock
Spreadsheet: 03f840e0-5a21-4e37-9db7-1d21d18ca1ec
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
[NAME] | Test | [NAME] | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6153-1 | Poa pratensis Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 04d528b6-9e15-4b91-b409-fe385676e793
Sheet: Sheet1

Date | GMT Start | GMT End | Acapulco Start | Acapulco End | Notes
2011-02-23 00:00:00 | [NAME] | 23:00:00 | 15:00:00 | 17:00:00 | R16
2011-02-24 00:00:00 | 01:00:00 | 03:00:00 | 19:00* | 21:00* | R16
 | 19:00:00 | 23:00:00 | 13:00:00 | 17:00:00 | QF 1 & 2
2011-02-25 00:00:00 | 01:00:00 | 05:00:00 | 19:00* | 23:00* | QF 3 & 4
 | 23:00:00 | 01:30:00 | 17:00:00 | 19:30:00 | SF1
2011-02-26 00:00:00 | 03:00:00 | 05:30:00 | 21:00* | 23:30* | SF2
2011-02-27 00:00:00 | 03:00:00 | 06:00:00 | 21:00* | 00:00:00 | Final
* Previous day
Spreadsheet: 144895d1331197965-copying-from-1-sheet-to-many-sheets-sales-records-sample
Sheet: DONALD SCARROT

SALES SETTLEMENTS & RECEIPTS RECONCILIATION
2012
[NAME] SCARROT
Date | Invoice No | Client Name | Accounting Code | Model | Delivery Date | Qty | [NAME] | Ex-Stock / On Order | Amount | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Balance |  |  |  |  | DELIVERED | DEPOSIT OF | CHECKING IF DEPOSIT IS EQUAL TO  60%
 |  |  |  |  |  |  |  |  |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  |  |  |  |  |  | SALAH
 |  |  |  |  |  |  |  |  |  | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No |  |  |  |  |  | ON:
 |  |  |  |  |  |  |  |  | € | € |  | € |  | € |  | € |  | € |  | € |  | € |  | € |  | €
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 702347d1604311107-formula-that-refernces-resource-to-give-a-monthly-total-resourcing1-v3
Sheet: Sheet 1

Resource Bandwidth HeatMap |  |  |  |  |  |  |  | Month |  |  | 10 |  | Year |  | 2020
Resource Name
 | Total Planned Hours on Projects This Month | hrs per day
[NAME]
[NAME]
Albion Park CSO's
Shell Cove Staff
[NAME]
APR Staff Project Group
Belinda McClelland
[NAME]
[NAME]
[NAME]
BP Team
Bundanoon Staff
Business SME
[NAME]
[NAME]
[NAME]
[NAME] Staff
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Goulburn Staff
[NAME]
[NAME]
Information Services officer
IS Team
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Lachlan McDonald
[NAME]
[NAME]
Maree
[NAME]
Marketing
Meagan Geary
[NAME]
[NAME]
[NAME]
Mount Terry Staff
Mount Warrigal Staff
Nicci Mclean
[NAME]
[NAME]
Queenbeyan Staff
RSM's
Shell Cove Staff
[NAME]
[NAME]
[NAME]
[NAME]
Trainers
Vernia Blundell
Warilla Staff
[NAME]
 | *Showing Sum of Planned Hours Per Day
 | ***This is automated Resorce Bandwidth HeatMap based on dummy data in the 'Data Sheet'. You can enter the actual data in the Data Sheet to see the HeatMap for your Team .
Spreadsheet: 217157d1361995077-fnding-lowest-number-within-a-range-simple-sample
Sheet: INSTRUCTIONS

 |  | Instructions - Risk Model and Projected Equity Curve
 |  | 1. Put the starting balance in A2 on the "Outcome" sheet for each account.
 |  | 2. Put the winning % for the system in the blue cell, [NAME] (may use historical or current estimate of the winning percentage).
 |  | Note that the actual winning % is listed in C1003, it will likely be a little different from the anticipated winning percentage, as this is based on a 'monte carlo' sample of trades.
 |  | 3. In G1, put the percentage of the account that will be risked per trade. For this spreadsheet this is assumed constant for all trades.
 |  | 4. In I1, put the profit multiple for the take profit point. [EXAMPLE: Stop Loss is 20 pips away, [NAME] point is 40 pips away, so Profit Multiple = 2]
 |  | 5. The % Scratch cell indicates the % of trades that are losers after the stop loss is set to the break-even point. Obviously a higher number of is
 |  | break even "losses" is desirible.
 |  | 6. You can see how changing the winning percentage, amount risked per trade, profit multiple and % scratch trades changes your equity curve at the bottom.
 |  | 7. You may also get a new sequence of random trades from http://www.random.org/nform.html and paste them into the B column from B2. [For this
 |  | example, there were 1000 integers generated between 1 and 100 in one column.]
 |  |  |  |  | Starting Bal. | Pred Win % | Act Win % | Act % Scratch | TP Multiple | Amount Risked Per Trade | Ending Balance |  |  | [NAME] |  |  | Min Balance |  |  | 100000
 |  |  |  | AUDJPY | 6000 | 59.5 | 0.59 | 0.116 | 0.925 | 0.02 | 772086.8202610122 |  |  | 772086.8202610122 |  |  | 6111 |  |  | 484
 |  |  |  | Outcome 2 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  | Outcome 3 | 6000 | 67.5 | 0.653 | 0.104 | 0.75 | 0.02 | 727691.3125096263 |  |  | 777278.8402670636 |  |  | 5968.2 |  |  | 578
 |  |  |  | Outcome 4 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  | Outcome 5 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  | Outcome 6 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  | Outcome 7 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  | Outcome 8 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  | Outcome 9 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  | Outcome 10 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 812872d1673433616-fonction-si-conditionnelle-ou-recherchev-bar-me-examen-exemple-in-english
Sheet: Feuil1

 | Barème examen locale 3AC
 | Course de vitesse |  |  |  | this is an example that i translated into english
Note /20 | 40m |  |  | n | name | sex | performance | note
 | garcons | Filles |  | 1 | LINA | Girl | 5.87 | 20
20 | 5.05 | 5.866666666666667 |  | 2 | FRED | boy | 5.7 | 17
19 | 5.3 | 6.066666666666666 |  | 3 | [NAME] | boy | 6.9 | 11
18 | 5.5 | 6.266666666666667 |  | 4 | MARIE | Girl | 7.07 | 14
17 | 5.7 | 6.466666666666666 |  | 5 | JEROM | boy | 6.5 | 13
16 | 5.9 | 6.666666666666666 |  | 6
15 | 6.1 | 6.866666666666667 |  | 7
14 | 6.3 | 7.066666666666666 |  | 8
13 | 6.5 | 7.266666666666667 |  | 9
12 | 6.7 | 7.466666666666666 |  | 10
11 | 6.9 | 7.666666666666666 |  | 11
10 | 7.1 | 7.866666666666667 |  | 12
9 | 7.3 | 8.066666666666666 |  | 13
8 | 7.5 | 8.266666666666666 |  | 14
7 | 7.7 | 8.466666666666665 |  | 15
6 | 7.95 | 8.666666666666666 |  | 16
5 | 8.15 | 8.866666666666667 |  | 17
4 | 8.35 | 9.066666666666666 |  | 18
3 | 8.55 | 9.266666666666666 |  | 19
2 | 8.75 | 9.466666666666665 |  | 20
1 | 8.95 | 9.666666666666666 |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
Spreadsheet: 122851d1317207241-excel-2007-using-indirect-formula-properly-stock-dummy
Sheet: Stock

Product | Code | Remaining Stock | Total orders | Total Sales
15X5 | TF01
15X5 | TF03
15X5 | TF04
15X5 | TF05
15X5 | TF07
8.5X6.25 | DC07
8.5X6.25 | DC50
8.5X6.25 | DC51
8.5X6.25 | DC52
Spreadsheet: benjamin_rogers__1189__Turbine Availability sheet
Sheet: 2000 Turbines

2000 Turbine Availability Sheet
Turbine Type | Quantity | MW/unit SC | Total MW | Hz | HR (Btu/kWh) HHV | Emissions PPM | New/Used | Schedule | Cost/unit (000) | Total Cost (000)
GE LM6000 | 24 | 48.58 | 1166 | 60 | 9805 | 25 | N | 1-3 July 2000,           4-6 Aug 2000,         7-8 Sept 2000,       9-11 Oct 2000,    12-13 Nov 2000,    14-15 Dec 2000,    16-18 Jan 2001,    19-20 Feb 2001,       21-22 March 2001,     23-24 April 2001 | $13,9500 avg   1-8 $13,800        9-16 $13,500   17-24 $13,200        Sprint option @ $450 per | 333500
GE 6B | 2 | 38.34 |  | 50 | 12050 | 25 | U | On hand | 12400
GE 7FA | 3 | 156.5 |  | 60 | 10610 | 9 | N | 1 - 8/31/2000, 2 - 9/30/00 | 32429
S/W 501 D5A | 1 | 119.845 |  | 60 | 11656 | 25 | N
F/W 501C-GT50 | 5 | 85.3 |  | 50 | 12761 | 25 | U |  | 10600
ABB 11N1 | 2 |  | 157.8 | 60 |  | < 25 | U
Spreadsheet: 822270d1679228459-formula-index-and-match-pontaj-2023-draft
Sheet: IANUARTIE

 |  | DATE | 2023-03-01 00:00:00
 |  | NORM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM |  |  | S | P | Z | N | H
 | 1 | 111 | Jhon | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S
 | 2 | 112 | [NAME] | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H
 | 3 | 113 | Adalyn | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N
 | 4 | 114 | [NAME] | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z
 | 5 | 115 | Beverly | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P
 | I am looking for a formula that will bring me in cells AS10-AW10, the names of the people that correspond to the shifts in the table. That is, in AS10 under shift S - the name [NAME], today being 19.03.2023. I think the INDEX and MATCH functions should solve this but they are probably doing something wrong as I always get #N/A or sometimes #REF error.
Spreadsheet: 40287d1238594330-cannot-save-formulas-with-weeknum-function-solved-with-workaround-weeknum-problem-dummy-workbook
Sheet: IS Lookup

IS_Abbreviation | IS_FullName
I/S AC | [NAME]
I/S AD | [NAME]
I/S AG | [NAME]
I/S AK | [NAME]
I/S BS | [NAME]
I/S CC | [NAME]
I/S CH | [NAME]
I/S CM | [NAME]
I/S DN | [NAME]
I/S EB | [NAME]
I/S EC | [NAME]
I/S GB | [NAME]
I/S JD | [NAME]
I/S JK | [NAME]
I/S JL | [NAME]
I/S KG | [NAME]
I/S LM | [NAME]
I/S LP | [NAME]
I/S MH | [NAME]
I/S RB | [NAME]
I/S SA | [NAME]
I/S SJ | [NAME]
I/S SM | [NAME]
I/S SN | [NAME]
I/S SO | [NAME]
I/S TE | [NAME]
I/S WC | [NAME]
I/S CD | [NAME]
I/S DB | [NAME]
Spreadsheet: 220491d1363180961-can-i-calculate-tax-percentage-deduction-based-on-individual-circumstance-payment-record
Sheet: 5 May (1)

PAYMENT RECORD
Name | job | payment refrence | gross | tax deducted | [NAME] added | amount paid | CIS | Paid | on return
MONTH ENDING 5/5/2012      PAYMENT DATE  06/04/12 |  |  |  |  |  |  |  |  |  | 1a
Company 1 | JOB 1 | 8/4641 | 1000 | 0 | 1000 |  | yes | yes | yes
MONTH ENDING 5/5/2012      PAYMENT DATE  15/04/12 |  |  |  |  |  |  |  |  |  | 1b
SUB 1 | JOB 1 | Payment 19 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 4 | JOB 1 | invoice 68 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 2 | JOB 1 | invoice 120 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 3 | JOB 1 | invoice 132 | 1000 | 0 | 0 |  | yes | yes | yes
MONTH ENDING 5/5/2012      PAYMENT DATE  29/04/12 |  |  |  |  |  |  |  |  |  | 1c
SUB 3 | JOB 1 | Payment 20 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 5 | JOB 1 | invoice 69 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 2 | JOB 1 | invoice 121 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 7 | JOB 1 | invoice 133 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 6 | JOB 1 | invoice 6 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 1 | JOB 1 | Invoice 1 | 1000 | 0 | 0 |  | yes | yes | yes
SUB 4 | JOB 2 | 6 / 58 | 1000 | 0 | 1000 |  | yes | yes | yes
Sub-Contractor | Tax Deducted
SUB 5 | 0.2
SUB 3 | 0.1
SUB 6 | 0.2
SUB 2 | 0.2
SUB 1 | 0.2
SUB 4 | 0
SUB 7 | 0.5
Spreadsheet: 94610d1294374207-expand-macro-range-interactive-valve-table-v1-test
Sheet: Sheet1

C7A
Building | Valve No. | Quantity | Controls A | Controls B | Other Buildings Controlled by Valve
C7A | 64 | 1-3 | Domestic | domesitc east | C8A, C3A
C7A | 65 | 2-3 | Domestic | domestic west | E3A, C8A
C7A | 66 | 3-3 | Fire | internal fire | C8A
Spreadsheet: 46761d1245703419-sumproduct-using-2-different-date-ranges-annual-student-report-report-template-06-22-09-fs
Sheet: Outreach Summary

Outreach Summary Report
Date | Notes |  | Attendance lookup
Reporter |  |  | 0 | Please Select
Outreach Advocate |  |  | 1 | Absences ARE NOT affecting student's performance
Type of Outreach |  |  | 2 | Absences ARE affecting student's performance
[NAME] |  |  | 3 | Tardies ARE NOT affecting student's performance
Grade/Subject per class |  |  | 4 | Tardies ARE affecting student's performance
Spreadsheet: 274014d1382983621-autofill-rules-id-contract-file-tracker-sample-2
Sheet: Contents

[NAME] | Client | Location | Contract File Documents | Date Created
[NAME] | Various | Various
CF00 | Various | Various | Job Trackers
CF01
CF02
CF03
CF04
CF05
CF06
CF07
CF08
CF09
CF10
CF11
CF12
CF13
CF14
CF15
CF16
CF17
CF18
CF19
CF20
CF21
CF22
CF23
CF24
CF25
CF26
CF27
CF28
CF29
CF30
CF31
CF32
CF33
CF34
CF35
[NAME]
CF37
CF38
CF39
CF40
CF41
CF42
CF43
CF44
CF45
CF46
CF47
CF48
CF49
CF50
[NAME]
CF52
CF53
CF54
CF55
CF56
CF57
CF58
CF59
CF60
CF61
CF62
CF63
CF64
CF65
CF66
CF67
CF68
CF69
CF70
CF71
CF72
CF73
CF74
CF75
CF76
CF77
CF78
CF79
CF80
CF81
CF82
CF83
CF84
CF85
CF86
CF87
CF88
[NAME]
CF90
CF91
CF92
CF93
CF94
CF95
CF96
CF97
CF98
CF99
CF100
CF101
CF102
CF103
CF104
[NAME]
CF106
CF107
[NAME]
CF109
CF110
CF111
CF112
CF113
CF114
CF115
CF116
CF117
CF118
CF119
CF120
CF121
[NAME]
CF123
CF124
CF125
CF126
CF127
CF128
CF129
CF130
[NAME]
CF132
CF133
CF134
CF135
CF136
CF137
[NAME]
CF139
CF140
CF141
CF142
CF143
CF144
CF145
CF146
CF147
CF148
CF149
CF150
CF151
CF152
CF153
CF154
CF155
CF156
[NAME]
CF158
CF159
CF160
CF161
CF162
[NAME]
CF164
CF165
CF166
CF167
CF168
CF169
[NAME]
CF171
[NAME]
CF173
[NAME]
CF175
CF176
CF177
CF178
CF179
CF180
CF181
CF182
CF183
[NAME]
CF185
[NAME]
CF187
[NAME]
Spreadsheet: 12b0aeed-30dc-407c-8af9-ef1cc8df78e5
Sheet: Form-Lunch-Supper Only

SFSP PRODUCTION RECORD
Number of Meals Planned: |  |  |  |  | Sponsor Name:
Children: |  |  |  |  | Site Name:
Adult: |  |  |  |  | Date:
Total meals prepared:
 | Menu component | Menu | Food Item or USDA Recipe No. | Serving Size | Quantity Prepared | Leftovers & Recycled Milk | Number Served
LUNCH-SUPPER | Meat/Meat Alternate |  |  |  |  |  | Children:        ______
 |  |  |  |  |  |  | Prog. Adults:  ______
 | Bread/Grains |  |  |  |  |  | Non-Prog
 |  |  |  |  |  |  | Adults:      _________
 | Fruit/Vegetable |  |  |  |  |  | Total          _________
 | Fruit/Vegetable
 | Milk
 | Other Foods
NOTES:
Spreadsheet: 698642d1602091638-nested-vlookup-with-indirect-function-sample
Sheet: 2016

Number | Name | Combo
2 | milk
32 | pez
3 | deef
100009 | asfggf
87654 | kihhj
9467 | dsds
1235 | tyhen
3567 | loki
876 | adds
988 | [NAME]
12345 | yuk