tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698382d1601967534-re-formula-to-ignore-specific-text-during-cell-reference-from-pivot-data-sample-data
Sheet: Sheet3

Region | Rep | Item | Units | Sum of Total |  |  |  | Region | Rep | Item | Units | Sum of Total
Central | [NAME] | Binder | 28 | 139.72
Central | [NAME] | Pencil | 14 | 18.06
Central | [NAME] | Pencil | 66 | 131.34
Central | [NAME] | Pencil | 75 | 149.25
Central | [NAME] | Binder | 46 | 413.54
Central | [NAME] | Binder | 80 | 719.2
Central | [NAME] | Pen | 27 | 539.7299999999999
Central | [NAME] | Pencil | 7 | -9
Central | [NAME] | Pencil | 53 | 68.37
Central | [NAME] | Binder | 11 | 54.89
Central | [NAME] | Binder | 94 | 1879.06
Central | [NAME] | Pen Set | 50 | 249.5
Central | [NAME] | Pencil | 36 | 179.64
Central | [NAME] | Pencil | 90 | 449.1
Central | Kivell | Binder | 50 | 999.4999999999999
Central | Kivell | Desk | 5 | 625
Central | Kivell | Pen Set | 42 | -1005.43
Central | Kivell | Pen Set | 96 | 479.04
Central | Morgan | Binder | 28 | 251.72
Central | Morgan | Pen Set | 55 | -6876.43
Central | Morgan | Pencil | 90 | 449.1
Central | Smith | Binder | 87 | 1305
Central | Smith | Desk | 2 | 250
Central | Smith | Pencil | 67 | -86.43
East | [NAME] | Binder | 29 | 57.71
East | [NAME] | Pen | 96 | 479.04
East | Jones | Binder | 4 | 19.96
East | Jones | Binder | 60 | 838.8
East | Jones | Pen | 64 | 575.36
East | Jones | Pen Set | 16 | 255.84
East | Jones | Pen Set | 62 | -3096.43
East | Jones | Pencil | 35 | 174.65
East | Jones | Pencil | 95 | -189.05
East | Parent | Binder | 81 | 1619.19
East | Parent | Pen | 15 | 299.85
East | Parent | Pen Set | 74 | 1183.26
West | Sorvino | Binder | 7 | 139.93
West | Sorvino | Desk | 3 | -825
West | Sorvino | Pen | 76 | 151.24
West | Sorvino | Pencil | 56 | 167.44
West | Thompson | Binder | 57 | 1139.43
West | Thompson | Pencil | 32 | 63.68
(blank) | (blank) | (blank) | (blank)
Grand Total |  |  |  | 4428.370000000001
Spreadsheet: 1ddd47f7-04bc-47d9-a340-830d2f8c3fb9
Sheet: Sheet1

1921 - 10th  Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Solbosch, Bruxelles, Belgium |  |  |  |  | 1921-09-18 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | Balloon Name | Landing Place | Distance km | Time
1 | SUI | [NAME] | Capt. [NAME] | [NAME] | Cpt. Louis | Zürich | Lambay Island/Ireland | 766 | 1900-01-01 03:24:00
2 | GBR | [NAME] | Capt. Percival |  |  |  | Stumble Head/Fishguard/Wales | 667.5
3 | USA | Upson | [NAME] |  |  |  | Braich-y-Pwell/Carnarvon/Wales | 664.5
4 | GBR | Baldwin | (Sq.Lead.) |  |  |  | Cardigan/Wales | 631
5 | ITA | Valle | Comm. [NAME] di |  |  | Trionfale IX | Aberaeron/Wales | 617
6 | ITA | Barbanti | C. |  |  |  | Llanelly/Wales | 603
7 | FRA | Dubois | Jules |  |  |  | Dolgelly/Wales | 599
8 | USA | Orman | Ward T.van |  |  |  | Exeter/England | 565 | 15:05:00
9 | SPA | Magdalena | E. |  |  |  | Treherbert/Cardiff/Wales | 558
10 | BEL | Labrousse | Capt. M. |  |  |  | Knigton/Wales | 542
11 | FRA | Bienaime | [NAME] |  |  |  | Blanc Olchoe/ Herefordshire/England | 532
12 | BEL | Demuyter | Ernest | [NAME] | [NAME] | Belgica II | Bridport/Dorset/England | 500 | 22:35:00
13 | FRA | Crombez | [NAME] |  |  |  | Rottingdean/Sussex/ England | 315
14 | USA | Hoffmann |  | [NAME] |  |  | Irish Sea | no res.
Spreadsheet: 6da2ca17-34a9-463b-85b6-5a4d7787e110
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5893 | 41159 | Charlotte | Ellis | GBR | 1025 | [NAME] | 00:02:24 | 00:32:52 | 00:02:05 | [NAME] | 1 | [NAME]
5893 | 25148 | [NAME] | Mosquera B1 | USA | 1023 | 00:26:40 | 00:02:47 | 00:38:01 | [NAME] | 00:24:15 | 2 | 01:34:25
5893 | 30795 | Sara | Butler | GBR | 1024 | 00:12:40 | 00:01:53 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 192130d1352315295-autofill-based-on-data-in-other-columns-excel-example
Sheet: Sheet1

 |  | Desired Result
TR1209205000 | P | SEARS ORDER 1 OF 2
TR1209205000 | S | SEARS ORDER 2 OF 2
TR1209205001 | P | SEARS ORDER 1 OF 2
TR1209205001 | S | SEARS ORDER 2 OF 2
TR1209205004 | P | SEARS ORDER 1 OF 1
TR1209205011 | P | SEARS ORDER 1 OF 1
TR1209205012 | P | SEARS ORDER 1 OF 4
TR1209205012 | S | SEARS ORDER 2 OF 4
TR1209205012 | S | SEARS ORDER 3 OF 4
TR1209205012 | S | SEARS ORDER 4 OF 4
Spreadsheet: 798994d1664869330-combined-cell-value-excel-help
Sheet: Sheet1

RAW DATA
Case ID | Description | Accessories Return/ Fault |  |  | Case ID | Description | Accessories Return/ Fault
ABC123 | DVD Player | Do not power up |  |  |  | DVD Player
ABC123 |  | Scratches |  |  | ABC123
ABC123 |  | Dents |  |  | ABC123
ABC123 |  | Power cable |  |  | ABC123
ABC123 |  | Remote |  |  | ABC123
ABC123 |  |  |  |  | ABC123
XYZ234 | 65 Inch TV | Screen crack |  |  | XYZ234 | 65 Inch TV
XYZ234 |  | Remote missing |  |  | XYZ234
XYZ234 |  | Power cable |  |  | XYZ234
XYZ234 |  |  |  |  | XYZ234
DFC987 | FloorMate | Water damage |  |  | DFC987 | FloorMate
DFC987 |  | Torn |  |  | DFC987
DFC987 |  | NIL |  |  | DFC987
DFC987 |  |  |  |  | DFC987
Required Result (Column C)
Product ID | Description | Fault(s)
ABC123 | DVD Player | Do not power up, Scratches, Dents, Power cable, Remote
ABC123
ABC123
ABC123
ABC123
ABC123
XYZ234 | 65 Inch TV | Screen crack, Remote missing, Power cable
XYZ234
XYZ234
XYZ234
DFC987 | FloorMate | Water damage, Torn, NIL
DFC987
DFC987
DFC987
Spreadsheet: 816154d1675402626-formula-to-get-min-and-max-with-conditions-paviot-cal
Sheet: Sheet2

Row Labels | Sum of Sales Qty | Sum of  Stock Qty
DTOTAL30-050 | 33 | 116
DTOTAL30-075 | 97 | 125
DTOTAL30-100 | 198 | 167 |  | 24.25
DTOTAL30-1000 | 1 | 23 |  | 49.5
DTOTAL30-1050 | 6 | 19 |  | 2
DTOTAL30-1100 | 0 | 14 |  | 2
DTOTAL30-1150 | 0 | 12 |  | 2
DTOTAL30-1200 | 2 | 8 |  | 2
DTOTAL30-125 | 275 | 146 |  | 2
DTOTAL30-150 | 310 | 153 |  | 68.75
DTOTAL30-175 | 273 | 150 |  | 77.5
DTOTAL30-200 | 334 | 143 |  | 68.25
DTOTAL30-225 | 215 | 169 |  | 83.5
DTOTAL30-250 | 322 | 129 |  | 53.75
DTOTAL30-275 | 276 | 151 |  | 80.5
DTOTAL30-300 | 234 | 165 |  | 69
DTOTAL30-325 | 158 | 173 |  | 58.5
DTOTAL30-350 | 227 | 161 |  | 39.5
DTOTAL30-375 | 180 | 161 |  | 56.75
DTOTAL30-400 | 120 | 193 |  | 45
DTOTAL30-425 | 140 | 164 |  | 30
DTOTAL30-450 | 118 | 176 |  | 35
DTOTAL30-475 | 69 | 175 |  | 29.5
DTOTAL30-500 | 102 | 177 |  | 17.25
DTOTAL30-525 | 49 | 161 |  | 25.5
DTOTAL30-550 | 99 | 155 |  | 12.25
DTOTAL30-575 | 31 | 185 |  | 24.75
DTOTAL30-600 | 55 | 154 |  | 4
DTOTAL30-650 | 77 | 92 |  | 13.75
DTOTAL30-700 | 38 | 100 |  | 19.25
DTOTAL30-750 | 26 | 92 |  | 4
DTOTAL30-800 | 16 | 89 |  | 4
DTOTAL30-850 | 12 | 85 |  | 2
DTOTAL30-900 | 9 | 85 |  | 2
DTOTAL30-950 | 13 | 17 |  | 2
DTOTAL90-050 | 15 | 109 |  | 2
DTOTAL90-075 | 44 | 132 |  | 2
DTOTAL90-100 | 108 | 149 |  | 4
DTOTAL90-1000 | 4 | 14 |  | 27
DTOTAL90-1050 | 1 | 13 |  | 2
DTOTAL90-1100 | 3 | 6 |  | 2
DTOTAL90-1150 | 0 | 7 |  | 2
DTOTAL90-1200 | 3 | 6 |  | 2
DTOTAL90-125 | 177 | 134 |  | 2
DTOTAL90-150 | 226 | 123 |  | 44.25
DTOTAL90-175 | 212 | 135 |  | 56.5
DTOTAL90-200 | 246 | 135 |  | 53
DTOTAL90-225 | 184 | 137 |  | 61.5
DTOTAL90-250 | 225 | 141 |  | 46
DTOTAL90-275 | 181 | 124 |  | 56.25
DTOTAL90-300 | 179 | 150 |  | 45.25
DTOTAL90-325 | 111 | 152 |  | 44.75
DTOTAL90-350 | 154 | 136 |  | 27.75
DTOTAL90-375 | 90 | 162 |  | 38.5
DTOTAL90-400 | 125 | 142 |  | 22.5
DTOTAL90-425 | 109 | 155 |  | 31.25
DTOTAL90-450 | 114 | 135 |  | 27.25
DTOTAL90-475 | 81 | 147 |  | 28.5
DTOTAL90-500 | 73 | 157 |  | 20.25
DTOTAL90-525 | 46 | 154 |  | 18.25
DTOTAL90-550 | 55 | 142 |  | 4
DTOTAL90-575 | 36 | 155 |  | 13.75
DTOTAL90-600 | 58 | 135 |  | 4
DTOTAL90-650 | 47 | 102 |  | 14.5
DTOTAL90-700 | 31 | 90 |  | 4
DTOTAL90-750 | 29 | 80 |  | 4
DTOTAL90-800 | 14 | 86 |  | 4
DTOTAL90-850 | 7 | 70 |  | 2
DTOTAL90-900 | 3 | 98 |  | 2
FLCB-BL | 45 | 225 |  | 2
FLCB-BR | 154 | 170 |  | 15.75
FLCB-GN | 152 | 199 |  | 50.8125
FLCB-GY | 268 | 141 |  | 110.1875
FLCB-HN | 45 | 211 |  | 122.75
FLCB-PZ | 265 | 171 |  | 4
FLCB-SRGY | 76 | 187 |  | 38.5
FLOD-10BL | 252 | 756 |  | 38
FLOD-10GN | 813 | 730 |  | 67
FLOD-10GY | 1763 | 526 |  | 4
FLOD-10PZ | 1964 | 468 |  | 66.25
Grand Total | 12903 | 11882 |  | 19
Spreadsheet: vkaminski__40935__s100068
Sheet: TelephoneService

 | Enron Information Services
 | For the Accounting Month of February, 2001
 | for Information Only - DO NOT PAY
 | Company: 0011 Enron Corp.   Cost Center: 100068 CORP-RAC-Risk Mgt Co
 | Dept | Dept Name | Account Code | Original Acctg Month | Phone Number | Name | Room | Amount | Description
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | 2-7613 | *Piekielniak-2 | n/a | 0.31 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Reasoner, [NAME] | n/a | 107.29 | Long Distance
Not in Group | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Stephan, Nick | n/a | 0.31 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Hagelmann, Bjorn | n/a | 32.73 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | LeBroc, Christian | n/a | 16.89 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | [NAME], [NAME] | n/a | 4.17 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Dalal, Sunil | n/a | 8.68 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Yuan, [NAME] | n/a | 1.26 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Paraschos, Nick | n/a | 73.31 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | *Fax-Risk Control | n/a | 15.93 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | *Fax-Risk EB2822A | n/a | 21.11 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Schultz, [NAME] | n/a | 14.69 | Long Distance
Moved to CC 100052 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Suttle, [NAME] | n/a | 137.78 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Hennessy, Rita | n/a | 23.78 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Adams, [NAME] | n/a | 14.55 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | [NAME],Minal | n/a | 4.37 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Davenport, [NAME] | n/a | 31.85 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Economou, [NAME] | n/a | 57.1 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Gorny, [NAME] | n/a | 5.33 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | *Modem-Murphy | n/a | 0.1 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Phillips, Rebecca | n/a | 0.31 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Port, [NAME] | n/a | 14.63 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | [PHONE] | Reasoner, [NAME] | n/a | 15.37 | Long Distance
 | 100068 | CORP-RAC-Risk Mgt Co |  | 200102 | ProcFee |  |  | 12.04 | Processing Fee
 | 100068 Total
 | Grand Total
Spreadsheet: chris_stokley__3991__Closing 062601 mkt sum final
Sheet: Feb Debtor

Market Notice
Summary of Final Settlement for March 2001
 |  | March Final
GMC Billings
Due to ISO |  | 98288.65
Due from ISO
Market Billings
Due From SCs |  | 142425386.26
Due To SCs |  | 142425377.73
Cash To Pay SCs | February | March | Combined
Collections
GMC collected from SCs | 792.15 | 14949.03
GMC collected from ISO | 0
Market AR collected from SCs | 2754904.04 | 41758784.5
Total Collections
Disbursements
GMC paid to SCs | 0 | -354556.52
GMC paid to ISO | 0
Total Disbursements
Total to Pay SCs
Payments to ISO Creditors will be made as soon as practicable
Payment wires indicate the invoice being paid.
Spreadsheet: 0094e62b-83ad-41dc-a935-a99c47b6f019
Sheet: Multiple Employee TS

DEPARTMENT NUMBER: |  |  |  | PERIOD ENDING |  | 2013-06-14 00:00:00 |  |  | V - VACATION |  |  |  | VF - VACATION FMLA
 |  |  |  |  |  |  |  |  | S - ILLNESS WITH PAY |  |  |  | SF - SICK FMLA
DEPARTMENT NAME: |  |  |  |  |  |  |  |  | P - PERSONAL LEAVE |  |  |  | PF - PERSONAL FMLA
 |  |  |  |  |  |  |  |  | H - HOLIDAY |  |  |  | [NAME] DUTY
APPROVED BY: |  |  |  |  |  |  |  |  | LT - LOST TIME |  |  |  | LF - FMLA
SIGNATURE: |  |  |  |  |  |  |  |  | UC - UNSCHEDULED CLOSING |  |  |  | FL -FUNERAL LEAVE
 |  |  |  |  |  |  |  |  |  | ** FOR PAYROLL USE ONLY **
EMPLOYEE NAME
EMPLOYEE NUMBER |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
Last, First | WK. 1 | Start Time
 |  | End Time
 |  | Lunch Period
 |  | Worked Hrs
 |  | Non-Worked Hrs
1234567
 |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
 | WK. 2 | Start Time
 |  | End Time
 |  | Lunch Period
 |  | Worked Hrs
 |  | Non-Worked Hrs
EMPLOYEE NAME
EMPLOYEE NUMBER |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
Last, First | WK. 1 | Start Time
 |  | End Time
 |  | Lunch Period
 |  | Worked Hrs
 |  | Non-Worked Hrs
1234567
 |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
 | WK. 2 | Start Time
 |  | End Time
 |  | Lunch Period
 |  | Worked Hrs
 |  | Non-Worked Hrs
EMPLOYEE NAME
EMPLOYEE NUMBER |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
Last, First | WK. 1 | Start Time
 |  | End Time
 |  | Lunch Period
 |  | Worked Hrs
 |  | Non-Worked Hrs
1234567
 |  |  | SAT | SUN | MON | TUES | WED | THUR | FRI |  | REG.HRS. | VAC. | SICK |  | OT.
 | WK. 2 | Start Time
 |  | End Time
 |  | Lunch Period
 |  | Worked Hrs
 |  | Non-Worked Hrs
Spreadsheet: 749494d1632840434-countifs-with-ifs-and-ands-test2-etaf-
Sheet: Sheet1

Acc Code | Customer Name | Postcode | Call Ref | Machine | Mc Type | Engineer | Fault Code
 |  |  | 54291 | 325590 | BRITVIC | 7013 | OE01 | 1- |  |  | 1) I need a formula that counts if the value in column H is "NF01" AND the value in column F is either "Cans", "Bottles", OR "[NAME]". I'm not sure how to factor in the either/or element for column F.
 |  |  | 54292 | 304450 | BRITVIC | 2030 | NF01 | 2-
 |  |  | 54293 | 315000 | BRITVIC | 2012 | NF01
 |  |  | 54294 | 327350 | CANS | 2012 | NF01 | 1000
 |  |  | 54295 | 312250 | HOT | 5004 | OE01 | 2000
 |  |  | 54296 | 332630 | HOT | 7000 | NF01 | 3000
 |  |  | 54297 | 333860 | HOT | 6007 | NF01 | 4000
 |  |  | 54298 | 301500 | BOTTLE | 6007 | NF01
 |  |  | 54299 | 325280 | HOT | 7015 | NF01
 |  |  | 54300 | 312250 | HOT | 5004 | OE01
 |  |  | 54301 | 181220 | BRITVIC | 6005 | NF01
 |  |  | 54302 | 192980 | SNACK | RF01 | RE01
 |  |  | 54303 | 329640 | HOT | 5011 | NF01 |  |  |  | 2) Column G contains engineer numbers, and the numbers correspond to a region. Any engineer number between 1000-1999 is East, between 2000-2999 is West, and so on. Is there a way to count how many times column H is "NF01" for each region?
 |  |  | 54304 | 196690 | SNACK | 5005 | TC01
 |  |  | 54306 | 329680 | COMBI | 7019 | NF01
 |  |  | 54307 | 338590 | HOT | 7010 | NF01
 |  |  | 54308 | 115880 | COMBI | 4023 | TC01
 |  |  | 54309 | 331640 | HOT | 2034 | NF01
 |  |  | 54310 | 320670 | HOT | 5019 | NF01
 |  |  | 54311 | 198370 | HOT | 2020 | NF01
 |  |  | 54312 | 176840 | HOT | 3013 | NF01
Spreadsheet: 124094d1318089692-countifs-and-averageifs-nfl-stats
Sheet: Table

By Age
 | 2007 |  | 2006 |  | 2005 |  | 2004
 | # | Avg | # | Avg | # | Avg | # | Avg
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: rick_buy__32955__Raptor 3b
Sheet: Summary

 | Raptor III Daily Position Report & Summary
 | Inputs:
 | Trade Date |  | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative | -231149859 | 0
 | Today's Activity
 | Cumlative Ending |  | 0
 | Notional Capacity
 | Credit Capacity
Spreadsheet: 005c9dfd-bfd3-4394-afb6-f407eb6c4da6
Sheet: Sheet1

BME Purchase Order Form
Requested by |  | Phone
Form Completed by |  | Date Completed |  | Date Needed
*If items are needed in 5 working days or less please provide a brief justification below.
[NAME] |  | Vendor URL
Chartfield to be charged |  | PeopleSoft Account Code
Approval Signature |  | Grant Signature
Item / Part No. | Description | Price/Unit | Quantity | Price | Code**
 | Total Less Shipping
 | Tax
 | Shipping
 | Grand Total
Special Instructions for purchasing (ex: temperature sensitive):
* Only one vendor per form  * If you have obtained a quote please attach and email the quote to [NAME].
** Code is for chemical lab supplies.  If you have questions please email [NAME] or Beverly Wright.
Special Instructions for purchasing (ex: temperature sensitive):
Revised July 2011
Spreadsheet: 729707d1619276753-if-formula-for-between-two-numbers-weekly-report-sample
Sheet: Raw_Data

Name of the Person | External Submittals | Zero Subs | > 3 & < 5 Subs | > 0 & < 5 Subs | > 5 Subs
A | 1
B | 3
C | 0
D | 5
E | 0
F | 1
G | 7
H | 1
I | 2
J | 0
K | 0
L | 1
M | 10
N | 6
O | 3
P | 0
Q | 1
R | 8
S | 0
T | 6
U | 1
V | 0
W | 7
X | 10
Y | 0
Z | 2
AA | 1
AB | 6
AC | 0
AD | 1
AE | 6
AF | 0
AG | 11
Spreadsheet: 741320d1626966875-possible-to-automate-formula-acv-automate-formula
Sheet: HFM

 | Entity Name
 |  | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020
Account | Account | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00
4200990 | Net Inventory T/O | 2.75415192743919 | 2.61777499450475 | 2.53857088148081 | 2.56724708583511 | 2.41974303230574 | 3.67 | 2.1
 | in Days T/O
 | T/O in months
 | Freight IN | 32.23182 | 6.89732 | 7.16114 | 21.41727 | 6.89732 | 32.23182 | 7.16114
 | Duties | 8.778269999999997 | 7.277290000000001 | 5.87 | 11.0915 | 19.3 | 8.778269999999997 | 51.04298999999999
 | P&L bookings
 |  |  |  |  | formula |  |  |  |  | formula |  |  |  |  | formula
 |  | 2020-08-01 00:00:00 |  |  |  |  | 2020-09-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00
 |  | How to automate the formula (highlighted in yellow), so I don't need to manually adjust the months to include in the calculation?  [NAME] should look at the months in row 7, and based on the number of months, sum the current + prior months.
Spreadsheet: 825906d1681631207-sumif-accumulative-and-by-month-book2-1-
Sheet: Report 

Car
Computer | 295 | 55 | 55 | 55 | 20 | 20 | 20 | 20 | 20 | 40 | 40 | 40 | 40
Table | 28 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 10 | 10 | 10 | 10
TV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4
 | * Date will change with Stroll Bar
 | * Column B to show accumulated balance
 | * For example, to show accumulated for each type, till 31/08/2021 (Sum of Column B to Column U in raw data tab)
 | *For the yellow part, to show the the sum base on Raw Data tab. (For example Column C = sumif Column V in Raw Data Tab etc etc)
9
Spreadsheet: 90560d1290296623-conditional-indirect-or-lookup-season-stats-test
Sheet: Stats

Skater | # of Bouts skated | Penalties
A | 1 | 22
B | 4 | 3
C | 4 | 15
D | 6 | 4
E | 2 | 21
F | 1 | 22
G | 3 | 22
H | 1 | 10
I | 5 | 20
Spreadsheet: 818554d1676911412-calculate-with-upper-and-lower-limit-percentage_20022023
Sheet: Blad1

Euwid |  |  |  |  |  |  | Nov. '22 | 849 |  |  |  | Q1 | Q2 | Q3 | Q4
Maand | Dec. | Jan. | Febr. | Ave. |  |  |  | +/- % |  |  | Euwid | -0.0822
Kraft | 938 | 913 | 900 |  |  |  |  |  | Q2 |  | HPE | -0.0737
Wellenstof | 735 | 705 | 695 |  |  |  |  |  |  |  | Solid | 0
Test 2 | 745 | 715 | 700
Totaal
Maand | Mrt. | Apr. | [NAME] | Ave.
Kraft |  |  |  |  |  |  |  |  | Q3
Wellenstof
Test 2
Totaal
Maand | Jun. | Jul. | Aug. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q4
Wellenstof
Test 2
Totaal
Maand | Sept. | Okt. | Nov. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q1 '24
Wellenstof
Test 2
Totaal
Wood |  |  |  |  |  |  | Nov. '22
Maand | Dec. | Jan. | Febr. | Ave. |  |  |  | +/- %
Kraft |  |  |  |  |  |  |  |  | Q2
Wellenstof
Test 2
Totaal
Maand | Mrt. | Apr. | [NAME] | Ave.
Kraft |  |  |  |  |  |  |  |  | Q3
Wellenstof
Test 2
Totaal
Maand | Jun. | Jul. | Aug. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q4
Wellenstof
Test 2
Totaal
Maand | Sept. | Okt. | Nov. | Ave.
Kraft |  |  |  |  |  |  |  |  | Q1 '24
Wellenstof
Test 2
Totaal
Solid board |  |  |  |  |  |  | Jul. '22
Maand | Jun. | Jul. | Aug. | Sept. | Okt. | Nov. | Ave. | +/- %
Kraft |  |  |  |  |  |  |  |  | Q1 '24
Wellenstof
Test 2
Totaal
Maand | Dec. | Jan. | Febr. | Mrt. | Apr. | [NAME] | Ave.
Kraft |  |  |  |  |  |  |  |  | Q3
Wellenstof
Test 2
Totaal
Spreadsheet: 284be799-4205-4fad-9a16-ff16bff5baf9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
266175 | 9151 | Shorty | [NAME] | NZL | 622 | 00:12:58 | 00:01:39 | 00:37:42 | 00:00:48 | 00:22:06 | 1 | 01:15:11
266175 | 33273 | [NAME] | [NAME] | NZL | 624 | 00:12:47 | 00:01:14 | 00:45:44 | 00:01:03 | 00:25:35 | 2 | 01:26:21
266175 | 33341 | [NAME] | [NAME] | NZL | 625 | 00:13:09 | [NAME] | 00:43:47 | 00:01:23 | [NAME] | 3 | 01:27:15
266175 | 81241 | Barrie | Eccles | NZL | 623 | 00:13:46 | 00:01:30 | 00:51:08 | 00:01:00 | 00:27:43 | 4 | 01:35:05
Spreadsheet: 614f5c69-f33d-4302-a119-97bb3cc73b2a
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
FCPEP | Test | FCPEP | C-Peptide, [NAME] (Includes Creatinine) | C-Peptide, [NAME] | Immunochemiluminometric Assay (ICMA) | [NAME], 24-hour graduated: 24Urine |  |  | 50 | mL | 50 mL aliquot from a 24-hour well-mixed 24-hour urine collection.  No preservative. Refrigerate specimen during collection, and  send specimen frozen, on dry ice, in a plastic, 60-mL urine bottle. Note:  	24-Hour volume is required on request form for processing. | Pediatric Minimum: 5.0 mL Note: | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Reference Range: C-Peptide, [NAME] (ng/mL) Adults 24 h:           29 - 119 Overnight fasting:   15 -   94 3 h post prandial:   13 - 339   24 hour excretion, C-Peptide (ug/24 h) Adults 24 h:   43 - 175   C-Peptide/Creatinine Ratio (ug/g) Adults 24 h:            37 - 113 Overnight fasting:    10 -   50 3 h post prandial:    29 - 169   24 hr Creatinine, [NAME] (mg/24h) Males              1000 - 2000 Females            800 - 1800   Creatinine, [NAME] (mg/dL)   Test Performed by: Esoterix Endocrinology                               4301 Lost Hills Road                               Calabasas Hills, CA 91301 | Monday through Thursday | 2-6 days | 4 - 12 days |  | Profile |  |  |  |  | Esoterix Endocrinology
FCPEP | [NAME] | URINE | [NAME] |  |  |  | Frozen | 30 days
FCPEP | Order Question | Z0235 | 24 hr [NAME] |  | Plain Text
FCPEP | Result | Z0235 | 24 hr [NAME] | 24 hr [NAME] | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
FCPEP | Result | Z0261 | C-Peptide, [NAME] | C-Peptide, [NAME] | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 13715-8
FCPEP | Result | [NAME] | 24 hour excretion, C-Peptide | 24 hour excretion, C-Peptide | Alphanumeric |  |  |  |  | ug/24 h |  |  |  |  |  |  |  |  |  | 55920-3
FCPEP | Result | [NAME] | C-Peptide/Creatinine Ratio | C-Peptide/Creatinine Ratio | Alphanumeric |  |  |  |  | ug/g |  |  |  |  |  |  |  |  |  | In Process
FCPEP | Result | Z0233 | 24 hr Creatinine, [NAME] | 24 hr Creatinine, [NAME] | Alphanumeric |  |  |  |  | mg/24 h |  |  |  |  |  |  |  |  |  | 2162-6
FCPEP | Result | Z0234 | Creatinine, [NAME] | Creatinine, [NAME] | Alphanumeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2161-8
FCPEP | Billing Component | FCPEP |  | Creatinine, other source |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82570
FCPEP | Billing Component | FCPEP |  | C-Peptide |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84681