tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 816266d1675455968-help-with-formula-stock_03022023
Sheet: Sheet1

EV-Box nr. | Art. nr. | Discription | Prod.date | Stock | Price.p.p. | Totale
TOPM182309 | 18162937 | [NAME] wegs pallet 1165x2000 | 2022-05-20 00:00:00 | 10 | 44.6
TOPM182309.1 | 18262937 | 4 wegs pallet [NAME], 1125x2000mm HT | 2022-08-19 00:00:00 | 36 | 51
TOP999415 | 21999415 | Level 2 Transport Box Handle | 2022-05-19 00:00:00 | 1000 | 0.3
 | 32999416 | Level 2 Fleece sheet 1600x2500mm | 2022-01-28 00:00:00 | 3040 | 1.41
 | 33004904 | Fefco 0201, [NAME]. 490x450x140mm | 2022-10-06 00:00:00 | 87 | 1.98
 | 33010600 | Elvi pole, [NAME] M180808 | 2022-01-12 00:00:00 | 396 | 6.6
 | 33020600 | Elvi pole omdoos M180787 | 2021-10-27 00:00:00 | 54 | 4.7
 | 33163141 | Fefco 0201, form. 855x175x96[NAME] | 2022-06-02 00:00:00 | 100 | 2.07
 | 33411002 | Fefco 0201, 355x355x145mm | 2021-08-18 00:00:00 | 40 | 2.1
 | 33411100 | [NAME] (M210041) | 2021-12-11 00:00:00 | 1126 | 1.75
 | 33411101 | Scorred Pad (M210032) | 2021-12-03 00:00:00 | 2040 | 0.7
 | 33411103 | Top Filling Plate (M210045) | 2021-12-04 00:00:00 | 1114 | 0.85
 | 35411001 | Scored pad 1200x//400 [NAME] | 2022-01-05 00:00:00 | 534 | 0.92
 | 35411006 | [NAME] (M210089) | 2021-11-25 00:00:00 | 277 | 5.9
 | 35811001 | Level 2 Scored sheet / reinforcement plate | 2022-08-23 00:00:00 | 753 | 10.55
 | 35899411 | Level 2 Transport Box US | 2022-10-06 00:00:00 | 805 | 10.55
 | 35999411 | Level 2 Transport box US | 2022-01-14 00:00:00 | 269 | 11.2
 | 35999427 | Double B-Line Socket + Cover Carton Outerbox | 2022-10-08 00:00:00 | 1040 | 2.68
 | 36899413 | Level 2 Transport Box Cable insert | 2022-08-26 00:00:00 | 529 | 1.82
 | 36899414 | Level 2 Transport Box Accessory Insert | 2022-08-26 00:00:00 | 547 | 2.45
 | 36999461 | elvi [NAME] Carton Insert | 2022-01-11 00:00:00 | 3500 | 0.45
 | 36999462 | Elvi Station Generic [NAME] | 2021-12-22 00:00:00 | 4240 | 1.68
 | 37899411 | Iqon pallet protection sheet 1120x1000mm | 2022-08-26 00:00:00 | 513 | 1.15
 | 37899460 | Elvi Cable Generic Carton | 2022-01-13 00:00:00 | 4800 | 1.85
 | 44311102 | PE Buffer Inside (M210040) | 2021-12-10 00:00:00 | 1100 | 1.35
 | 44411104 | PE Corner [NAME] (M210080) | 2021-12-10 00:00:00 | 9000 | 0.98
 | 44899412 | Level 2 Transport Box PE Insert | 2022-09-02 00:00:00 | 992 | 11.75
 | 44999412 | Level 2 Transport Box PE Insert | 2021-12-24 00:00:00 | 186 | 11.75
 | 44999439 | Double B-Line + Cover PE foam sheet | 2022-01-21 00:00:00 | 3828 | 2.41
 | 60799466 | Elvi Table kWh UL | 2021-04-27 00:00:00 | 1120 | 0.98
 | 60999465 | [NAME] | 2022-06-23 00:00:00 | 3218 | 1.25
 | Totale
Spreadsheet: 692526d1598412942-extrapolate-roll-existing-data-in-same-format-extrap-dummy-losincog-
Sheet: 28

Stat | Assignment | DocumentNo | Type | SG | DD | Clrng doc. | Text | CoCd | Doc. Date | Amount in local cur. | LCurr | Amount in doc. curr. | Curr. | Pmnt date | Day1 | Day1: | 14 | Months: | 12 | Clrng doc.: | 12345
Spreadsheet: 183952d1349101305-blank-cells-in-worksheet-fill-blanks-below
Sheet: Sheet1

Before |  | Need |  | [NAME]
316L+GRAPH SPW |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW | << Look at this formula and pull down.
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW |  | You can copy and paste values only
S31803/GRAPH |  | S31803/GRAPH |  | S31803/GRAPH |  | to revove the formulas if you want
 |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
316L+GRAPH SPW |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
 |  | 316L+GRAPH SPW |  | 316L+GRAPH SPW
S31803/GRAPH |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
 |  | S31803/GRAPH |  | S31803/GRAPH
S31803/GRAPH |  | S31803/GRAPH |  | S31803/GRAPH
Spreadsheet: 772254d1647114638-to-calculate-fuel-sur-charge-for-certain-customers-test-load-sheet-etaf
Sheet: Sheet1

Date | Customer Name | Destination/Job | Ticket # | [NAME] | Price Per Ton | Gross Revenue
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Gross | 0 |  |  | 0 |  | 0
[NAME]
0.1 | 0
W/C | 80
Aflac | 76.53
BC/BS Insurance | 106.5
Truck Insurance | 0
Net | -263.03
Spreadsheet: 752343d1634724525-copy-cells-with-values-filter-value-chart-aligw
Sheet: Sheet1

How to from here |  |  | TO here
Name | Value |  | Name | Value
Name 1 | 12 |  |  | 12
Name 2 | 1 |  | Name 2 | 1
Name 3 | 1 |  | Name 3 | 1
Name 4 |  |  | Name 9 | 25
Name 5 |  |  | Name 14 | 12
Name 6 |  |  | Name 20 | 15
Name 7 |  |  | Name 25 | 3
Name 8
Name 9 | 25
Name 10
Name 11
Name 12
Name 13
Name 14 | 12
Name 15
Name 16
Name 17
Name 18
Name 19
Name 20 | 15
Name 21
Name 22
Name 23
Name 24
Name 25 | 3
Name 26
Name 27
Spreadsheet: 582696d1532004814-need-to-fill-a-table-from-a-data-sheet-by-a-reference-no-online-1-
Sheet: Sheet1

Return Gate Pass
Ceylon Steel Coporation Ltd.
 |  |  |  |  | NO: | 2
Date: |  |  |  | Taken By:
Dept/Mill: |  |  |  | Emp/ID No:
Delivery To: |  |  |  | Vehicle No:
 |  |  |  | Return Date:
S/ No. | Description |  |  | Identification No. | UOM | Qty
1.
2.
3.
4.
5.
6.
7.
Requested By:
date | NO | mill/dept | description | identfctn no | uom | qty | place | Requested By: | Taken By: | id | vehicle | Return Date:
2018-07-17 00:00:00 | 1 | rm | spare part | sd54fs3 | nos | 10 | [NAME] | [NAME] | kasun | 5385 | [NAME] | 22/7/18
2018-07-17 00:00:00 | 1 | rm | spare part | 654as54as | nos | 10 | [NAME] | [NAME] | kasun | 5385 | [NAME] | 22/7/18
18/07/2018 | 2 | pm | machine | a5s4d54 | nos | 6 | hardware | gamini | pradeep | 5468 | wl-7954 | 30/07/2018
2018-07-19 00:00:00 | 3 | pm | hard disk | a45sd4 | nos | 4 | hardware | gamini | pradeep | 5468 | wl-7954 | 30/07/2018
Spreadsheet: 62234d1263222448-conditional-formating-based-on-a-date-example
Sheet: Sheet1

WIP | Customer name | Reg No | Make/model | Service text | Next serv | MOT due date | Text Notes
43407 | Mr I Tebbitt | KW56TCV | Peugeot 407 Se | MOT TEST | 2009-12-10 00:00:00 | 2010-01-24 00:00:00
44372 | Mr N Humphrey | GV53UJA | 206 Quicksilver | Carried out MOT test | 2011-01-24 00:00:00 | 2011-01-24 00:00:00 | 340.00 TOTAL
44427 | Mrs J B Hyam | KR54LPN | Peugeot 307 SW | Carried out MOT test | 2010-01-15 00:00:00 | 2010-01-15 00:00:00
44506 | L & S Printing Company | YK57XEJ | [NAME] | INVESTIGATE NO MOBIL | 2010-05-19 00:00:00 | 2010-09-28 00:00:00 | TONYS FRIEND
44538 | Mrs J Smith | KM03HCC | 807 2.0 Executi | INVESTIGATE KNOCKING | 2010-02-27 00:00:00 | 2010-04-23 00:00:00
44546 | Miss J [NAME] | GP57HFH | Peugeot 308 1.6 | Supply and fit new l | 2010-01-07 00:00:00 | 2011-01-19 00:00:00
44586 | Mr G H Prinn | X119YFG | Peugeot [NAME] | Carried out MOT test | 2009-01-09 00:00:00 | 2009-01-16 00:00:00 | claire to [NAME] as he fancies
44638 | Miss B Melaniphy | GY05XDS | 206 | Investigated tempera | 2010-04-04 00:00:00 | 2010-04-04 00:00:00
44691 | Mr P King | GR53HKA | 307 1.4 16V Env | MOT TEST | 2009-01-20 00:00:00 | 2010-01-19 00:00:00
44711 | Mr [NAME] | R943HKX | VOLKSWAGON POLO | MOT TEST | 2010-01-11 00:00:00 | 2010-01-11 00:00:00
44717 | Ms S Whitcombe | GV07ZYC | Peugeot Expert | Investigate N/S head | 2010-03-03 00:00:00 | 2010-03-31 00:00:00
44718 | Mrs B Tarjanyi | GY54NLT | Peugeot 307 2.0 | INVESTIGATE HEADLAMP | 2010-09-29 00:00:00 | 2010-09-29 00:00:00 | DO BULB TODAY, SAID WILL HAV
44721 | [NAME] | GP52GDO | Ford Fusion 16v | MOT TEST | 2010-08-21 00:00:00 | 2010-01-12 00:00:00
44732 | Mr [NAME] | KW51CMF | PEUGEOT 406 | SUPPLIED AND FITTED | 2010-04-01 00:00:00 | 2010-04-01 00:00:00
44736 | Mr Hicks | LG57BSO | Peugeot 207 | INVESTIGATE ENGINE W | 2009-11-28 00:00:00 | 2010-11-28 00:00:00
Spreadsheet: 762398d1641544077-combine-columns-in-two-filter-functions-book2-1-
Sheet: Sheet1

Fruits | Price | Date | Pieces |  |  | Fruits | Date | Pieces
Apple | 5 | 2022-12-01 00:00:00 | 50 |  | From |  | 2022-12-01 00:00:00 | 50 |  |  |  | 2022-12-01 00:00:00 | 50 |  |  | 44896 | 50
Apple | 5 | 2022-12-02 00:00:00 | 50 |  |  | Apple | 2022-12-02 00:00:00 | 50 |  | to | Apple | 2022-12-02 00:00:00 | 50 |  | Apple | 44897 | 50
Lemon | 3 | 2022-12-01 00:00:00 | 50 |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  |  |  |  |  |  | Tomato | 2022-12-08 00:00:00 | 20
 |  |  |  |  |  |  | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  | Tomato | 2022-12-08 00:00:00 | 20
 |  |  |  |  |  | Vegs | Price | Date | Pieces
 |  |  |  |  |  | Tomato | 5 | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  | Lettuce | 5 | 2022-12-02 00:00:00 | 30
 |  |  |  |  |  | Tomato | 3 | 2022-12-08 00:00:00 | 20
Spreadsheet: 40036d1238356834-countif-sin90-report
Sheet: Validation

Activity Number | Primary Resolution | Cust Acct Number | Service Duration Days | Prior Order Subtype | Prior Tech Login | Prior Tech Team
1-JKKTZPO | IRD Replace HD/DVR Combo | 4204238 | 66 | Upgrade | ASGA001087 | 402 ODU VALIDATION | 1
1-KE4TABN | Customer Education Other | 38090725 | 70 | Service | ASGA001115 | 402 ODU VALIDATION
1-JTXIST2 | IRD Replace Standard | 51426927 | 22 | Service | ASGA001115 | 402 ODU VALIDATION
1-JVDBEAV | ODU Replace KA/KU | 32463895 | 63 | Service | ASGA001115 | 402 ODU VALIDATION
1-KB42XC1 | Customer Caused | 81998926 | 71 | New Install | ASGA001115 | 402 ODU VALIDATION
1-KQ4CUDK | LNB Replace Dual | 32258418 | 33 | Service | ASGA001115 | 402 ODU VALIDATION
1-L0HPGKO | IRD Replace HD/DVR Combo | 57431334 | 50 | Service | ASGA001115 | 402 ODU VALIDATION
1-JIRORGQ | [NAME] | 56701805 | 25 | Upgrade | ASGA001115 | 402 ODU VALIDATION
1-JOPSY5T | Cable Replace From IRD | 80817710 | 3 | Upgrade | ASGA001115 | 402 ODU VALIDATION
1-JQ33XXR | IRD Replaced HD IRD | 8251202 | 79 | Upgrade | ASGA001115 | 402 ODU VALIDATION | 9
1-KE2SRKH | Cable Replace From Ground | 69151895 | 17 | Service | ASGA001195 | 402 ODU VALIDATION
1-JZDBUHB | Cable Replace From ODU | 11230298 | 27 | Former Install | ASGA001195 | 402 ODU VALIDATION
1-JZJDYGM | Connectors Replaced Ground Blk | 44399954 | 48 | Service | ASGA001195 | 402 ODU VALIDATION
1-K1KKDXZ | Replace 4 way splitter | 51634460 | 22 | New Install | ASGA001195 | 402 ODU VALIDATION
1-K4XEKBT | ODU Peak KA/KU | 27385011 | 7 | Service | ASGA001195 | 402 ODU VALIDATION
1-KEOAZ6G | Cable Replace From Ground | 56597977 | 59 | Service | ASGA001195 | 402 ODU VALIDATION
1-KGO7MH7 | IRD Replace HD/DVR Combo | 7277386 | 12 | Former Install | ASGA001195 | 402 ODU VALIDATION
1-JPUEWFV | ODU [NAME] 18x20 | 80784143 | 55 | Former Install | ASGA001195 | 402 ODU VALIDATION
1-JQ5VYPQ | Multiswitch Replace 4x8 | 44227610 | 12 | Upgrade | ASGA001195 | 402 ODU VALIDATION | 9
Spreadsheet: 680490d1591044800-substitute-formula-not-work-substitute
Sheet: Sheet1

[NAME] nice car
Galaxy, star wars
London, England
Excel best VBA
Spreadsheet: 861621d1709512584-groupby-does-not-sum-the-entire-array-provided-groupby-function-horizontal-sum
Sheet: 1

Name | ID | Product | JAN | FEB | MAR | APR | MAY | JUN
Company A | 1 | A | 1133000 | 1053000 | 1133000 | 259000 | 0 | 40000
Company Z | 26 | B | 259000 | 385000 | 1053000 | 385000 | 1000 | 42000
Company B | 2 | C | 0 | 1000 | 1133000 | 1053000 | 1133000 | 1053000
Company C | 3 | A | 40000 | 42000 | 259000 | 385000 | 259000 | 385000
Company A | 1 | C | 149000 | 231000 | 0 | 1000 | 0 | 1000
Company D | 4 | C | 29000 | 18000 | 40000 | 42000 | 40000 | 42000
Company F | 6 | D | 204000 | 224000 | 149000 | 231000 | 149000 | 231000
Company G | 7 | C | 23000 | 79000 | 29000 | 18000 | 29000 | 18000
Company C | 3 | E | 1270000 | 983000 | 204000 | 224000 | 204000 | 224000
Company Z | 26 | C | -8000 | 1000 | 23000 | 79000 | 23000 | 79000
 |  | Company | Q1
 |  |  | 1282000 | 1284000 | 1133000
 |  | 2 | 0 | 1000 | 1133000 |  | 1134000
 |  | 3 | 1310000 | 1025000 | 463000 |  | 2798000
 |  |  |  | 2310000 | 2729000
Spreadsheet: 263382d1378463728-to-summarized-the-datas-from-the-details-workings-by-given-the-single-input-costing-table
Sheet: Summary

 | EXPECTED RESULT
 | FNDADRKCC | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00
 | Model Code | CNDKDRSCC | CNDKDRSCC | CNDKDRSCC | CNDKDRSCC | CNDKDRSCC
 | Prod.Qty
 | CKD
 | Local
 | E.Oil
 | Paint Cost
 | Steel
 | TOTAL MATERIAL COST
Spreadsheet: e3615db0-975a-40fc-8602-3f2a8a1dc85c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
261049 | 56627 | [NAME] | Vandendriessche | BEL |  | 00:47:15 | 00:00:52 | 01:30:07 | 00:01:08 | 00:28:21 | 1 | 02:47:42
261049 | 57033 | [NAME] | Buyle | BEL |  | 00:48:18 | 00:01:04 | 01:35:48 | 00:01:09 | 00:26:47 | 2 | 02:53:05
261049 | 27366 | [NAME] | Melnikov | RUS |  | 00:48:22 | 00:01:01 | 01:43:49 | 00:01:06 | 00:32:08 | 3 | 03:06:24
261049 | 46677 | [NAME] | Speight | IRL |  | 00:49:43 | 00:01:23 | 01:49:44 | 00:01:22 | [NAME] | 4 | 03:12:13
261049 | 46793 | Igor | [NAME] | RUS |  | 00:52:11 | 00:01:09 | 01:45:21 | 00:02:24 | 00:37:19 | 5 | 03:18:23
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: Planning

Detail No. | Quantity | Overall Estimated Total | Sub-Contract | Specify Bought-Out Sizes/Material Alternative | Obtaining Drawings/CAD Files/Missing Data | Organizing Tooling & Machine Availability (Tools, Machines, Jigs & Fixtures) | Other | Total Time (hours) | NOTES
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  | 0
. |  |  |  |  |  | Grand Total |  | 0
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 55927 | 56112
2 | 45352 | 41112
3 | 39348 | 38072
4 | 57516 | 58575
5 | 38360 | 38612
6 | 38227 | 38612
7 | 38252 | 38612
8 | 53083 | 55820
9 | 32289 | 18110
10 | 38336 | 40659
11 | 45961 | 45820
12 | 58658 | 58864
13 | 58648 | 58864
14 | 53073 | 52864
15 | 43337 | 45610
16 | 42964 | 45253
17 | 48358 | 50595
18 | 46348 | 48259
19 | 57495 | 59137
20 | 59012 | 59137
21 | 47402 | 49004
22 | 56240 | 57866
23 | 43863 | 42889
24 | 34764 | 33119
25 | 38311 | 38495
26 | 48358 | 48579
27 | 47843 | 48579
28 | 37363 | 38446
29 | 26206 | 25081
30 | 27380 | 27362
31
2001-12-31 00:00:00 |  |  | 4822.84
2002-01-30 00:00:00
CBS Volume
 |  |  | 2134
Spreadsheet: 883559d1732183300-trying-to-count-dates-before-today-from-a-filtered-column-book1
Sheet: Sheet2

Backlog | =SUBTOTAL(3,Table1[Shipment Date],"<="(TODAY())) |  |  |  |  |  | B1 - Trying to count any dates sheet 1 before today, that have not been filtered out, this should currently be '0' but I cannot get this formula to work at all
 |  |  |  |  |  |  | B2 - trying to count dates on sheet 1 matching A2 that haven't been filtered out, but the formula I'm using is just counting everything that remains after the filer is applied
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -21114 | -20165
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -1139133 | -1048668
58710 | -16556 | -726
60921 | 733695 | 650060
78026 | 4449 | 26266
500084 | -5860 | -11000
500085 | -1916
500097
INDEX
2001-05-31 00:00:00 |  |  | 597578.71
2001-06-11 00:00:00
Spreadsheet: 164558d1340809998-countif-unique-values-only-cells-with-numbers-test1
Sheet: List1

RN |  | SV
1 |  | -
1 |  | -
1 |  | 1
1 |  | 2
1 |  | 3
1 |  | 4
1 |  | 4
1 |  | 5
1 |  | 6
1 |  | 7
2 |  | 8
2 |  | 9
2 |  | 10
2 |  | 10
2 |  | 11
3 |  | -
3 |  | 12
3 |  | 12
3 |  | 13
3 |  | 14
Spreadsheet: 536290d1504355398-min-if-function-across-multiple-worksheets-min-if-test-sheet-1-
Sheet: 2017

Project name | Date | Invoice
A | 2017-01-01 00:00:00 | 2700
B | 2017-01-01 00:00:00 | 1000
C | 2017-01-01 00:00:00 | 1800
D | 2017-01-01 00:00:00 | 2100
E | 2017-01-01 00:00:00 | 400
A | 2017-02-01 00:00:00 | 600
B | 2017-02-01 00:00:00 | 1900
D | 2017-02-01 00:00:00 | 1800
E | 2017-02-01 00:00:00 | 200
A | 2017-03-01 00:00:00 | 3100
B | 2017-03-01 00:00:00 | 3500
C | 2017-03-01 00:00:00 | 800
B | 2017-04-01 00:00:00 | 1400
C | 2017-04-01 00:00:00 | 1500
E | 2017-04-01 00:00:00 | 2000
F | 2017-04-01 00:00:00 | 700
A | 2017-05-01 00:00:00 | 1000
B | 2017-05-01 00:00:00 | 500
D | 2017-05-01 00:00:00 | 1800
F | 2017-05-01 00:00:00 | 1300
Spreadsheet: 117f5a4e-33fb-4311-a7cd-06482cc78e92
Sheet: Sheet1

Unnamed: 0 | University SBF Expense Claim Form | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | CARS IV# |  |  |  | Check, U.S. Mail
 | Date Rec'd in A/P |  |  |  | Address
 |  |  |  |  | City, State & Zip Code
 | CARS ID# |  | Acct# |  | Check, specify      Campus Mail      Hold for pickup
BU Faculty/Staff | Payee Name
BU Student | SS# if no CARS ID# |  |  |  | Dept |  |  | Ext #
Other |  | A | B | C | D |  | E | F | G
Purpose, Destination, Explanation & Other Required Information | Date of Expense/Receipt (MM/DD/YYYY) | Personal Auto Mileage (32000) | Airfare, Taxis (32000) | [NAME] (35000) | Lodging (32000) |  | Meals (34100) | Conference Fee (54000 Fac) (54500) Staff | Other Expenses (Explain)
Claims for expenses should be submitted every | Total Miles | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
30 days according to BU policy.  The IRS requires reimbursement requests to be filed within 60 days of the expense.   The date the form is received in Accounts Payable is considered the date of consideration for the 60 days.   If reimbursement is approved on those expenses submitted past 60 days, reimbursement will be via payroll as "other income." | Calculation @ $0.46 per mile | 0 | Enter only numbers in columns A-G so the formulas can total the columns.  Original receipts are required for all expenses in Columns B, C, D, E, F & G.  For meals, the detail menu receipt must be submitted as well.
 |  |  |  |  |  |  | Column Totals of A, B, C, D, E, F & G |  | 0
Payee's Signature
 | Signature denotes expenses are in compliance with University policies and procedures |  |  |  |  |  | Less personal expenses
 |  |  |  |  |  |  | Less Cash Advance
Director of Student Activities |  |  |  |  |  |  | Due to payee/(Bellarmine) |  | 0
SGA Vice President of Finance
Account # | Amount | Account # |  |  | Amount |  | Entered by A/P  (initials)
Account # | Amount | Account # |  |  | Amount |  | Approved by (initials)
9.9.1                                                                       TRAVEL AND ENTERTAINMENT REIMBURSEMENT
Spreadsheet: 784346d1655656535-total-days-per-month-total-days-per-month
Sheet: Sheet1

No | ID | Name | Date From | Date To | Days | Check | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
1 | 112 | Mr [NAME] | 2022-01-09 00:00:00 | 2022-02-05 00:00:00 |  |  | 22 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 548 | Mr Beta | 2022-03-15 00:00:00 | 2022-04-10 00:00:00 |  |  | 0 | 0 | 16 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 447 | Miss [NAME] | 2022-04-25 00:00:00 | 2022-05-15 00:00:00 |  |  | 0 | 0 | 0 | 5 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 548 | Miss Delta | 2022-06-29 00:00:00 | 2022-08-18 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 31 | 18 | 0 | 0 | 0 | 0
Spreadsheet: d1385967-d0bc-4970-8af3-4da14dce322a
Sheet: Annual Avg.

Railroad Fuel Surcharges --Annual and Quarterly Averages
 | Mileage-based ($/mile) |  |  |  |  |  |  |  |  |  |  | As a percent of tariff
 |  |  |  |  |  |  |  | [NAME]. | Weighted |  |  |  |  |  |  |  |  |  | [NAME]. | Weighted
 | BNSF | CN | CP | CSXT | KCS | NS | UP | Average | Average |  |  | BNSF | CN | CP | CSXT | KCS | NS | UP | Average | Average
2003 average |  |  |  |  |  |  |  |  |  |  | 2003 average
2004 average |  |  |  |  |  |  |  |  |  |  | 2004 average
2005 average |  |  |  |  |  |  |  |  |  |  | 2005 average
2006 average |  |  |  |  |  |  |  |  |  |  | 2006 average
2007 average
2008 average
2009 average
2010 average
2011 average
 | Wt. [NAME].
 | [NAME]
 | by Quarter
4Q01
1Q02
2Q02
3Q02
4Q02
1Q03
2Q03
3Q03
4Q03
1Q04
2Q04
3Q04
4Q04
1Q05
2Q05
3Q05
4Q05
1Q06
2Q06
3Q06
4Q06
1Q07
2Q07
3Q07
4Q07
1Q08
2Q08
3Q08
4Q08
1Q09
2Q09
3Q09
4Q09
1Q10
2Q10
3Q10
4Q10
1Q11
2Q11
3Q11
4Q11
1Q12
Spreadsheet: f072e007-4875-4664-9cc2-39595f6e53fe
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40918252 | 2014-04-09 20:52:51 | AXIS | 0 | 2 | 5 | 1249072 | player1249072 | 9597 | western | 1944-06-06 | 1944-06-06 | Utah Beach | Utah Beach
40954292 | 2014-04-12 13:15:34 | AXIS | 1 | 10 | 7 | 946197 | Groka | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40977964 | 2014-04-13 22:50:54 | AXIS | 0 | 4 | 6 | 637960 | kurivial | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
40978111 | 2014-04-13 23:06:18 | ALLIES | 0 | 5 | 6 | 637960 | kurivial | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
40978322 | 2014-04-13 23:30:00 | AXIS | 0 | 5 | 6 | 971161 | mschoenh | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
41001124 | 2014-04-15 14:35:50 | AXIS | 1 | 5 | 0 | 1449105 | p-h-hildenbrand | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
41062315 | 2014-04-19 17:57:41 | AXIS | 1 | 4 | 1 | 1532086 | [NAME] | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
41062469 | 2014-04-19 18:09:31 | AXIS | 0 | 3 | 6 | 1345830 | player1345830 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
41062618 | 2014-04-19 18:22:44 | ALLIES | 1 | 6 | 3 | 1345830 | player1345830 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
41075941 | 2014-04-20 16:44:17 | AXIS | 1 | 10 | 6 | 1004418 | lingfields | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
41076338 | 2014-04-20 17:17:00 | ALLIES | 1 | 10 | 5 | 1004418 | lingfields | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
41076802 | 2014-04-20 17:30:41 | AXIS | 1 | 6 | 2 | 767699 | nap1815 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
41076985 | 2014-04-20 17:53:24 | ALLIES | 0 | 5 | 6 | 767699 | nap1815 | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel