tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 197785d1354560608-problems-with-sumproduct-need-help-badly-sumproduct-example
Sheet: Sheet1

 |  |  |  |  |  | Critical |  | 1
 |  | Test Name | Launch Priority | Status |  | High |  | 2 |  |  | Total Cases
 |  |  |  |  |  | Medium |  | 3 |  |  | Passed
 |  |  |  |  |  | Low |  | 4 |  |  | Quality Issues
 |  |  |  |  |  |  |  | 5 |  |  | Failed
 |  | A | Medium | Pending |  |  |  | Pending |  |  | Pending
 |  | B | Medium | 2
 |  |  |  |  |  |  |  |  |  | Priority | Critical | High | Medium | Low
 |  |  |  |  |  |  |  |  |  | Passed
 |  | C | High | 3 |  |  |  |  |  | [NAME]
 |  | D | Critical | 3 |  |  |  |  |  | Failed
 |  | E | High | Pending |  |  |  |  |  | Pending
 |  | F | High | 4
 |  | G | Critical | Pending
 |  | H | High | Pending
 |  | I | Critical | 4
 |  | J | High | Pending
 |  | K | High | Pending
 |  | L | High | Pending
Spreadsheet: 203236d1356988763-automatically-populate-data-to-multiple-sheets-populate-data
Sheet: Entertainment

Date | Day | Time | Content Pillar | Platform | Program | Status Update | Approval Date | Social Comments | Product Team Comments
2013-01-04 00:00:00 | Friday | 9AM CST | Entertainment | 1 | 1 | [NAME] | [NAME] yada
2013-01-07 00:00:00 | Monday | 7PM CST | Entertainment | 1 | 5 | [NAME] | [NAME] yada
2013-01-08 00:00:00 | Tuesday | 6PM CST | Entertainment | 1 | 6 | [NAME] | [NAME] yada
2013-01-09 00:00:00 | Wednesday | 9AM CST | Entertainment | 1 | 2 | [NAME] | [NAME] yada
2013-01-10 00:00:00 | Thursday | 5PM CST | Entertainment | 1 | 8 | [NAME] | [NAME] yada
2013-01-11 00:00:00 | Friday | 4PM CST | Entertainment | 1 | 7 | [NAME] | [NAME] yada
2013-01-13 00:00:00 | Sunday | 10AM CST | Entertainment | 1 | 4 | [NAME] | [NAME] yada
2014-01-14 00:00:00 | Monday | 10AM CST | Entertainment | 1 | 1 | [NAME] | [NAME] yada
Spreadsheet: 757760d1638449082-split-value-across-a-date-range-based-on-a-start-date-split-value-across-date-range
Sheet: Sheet1

House | Qty | Start Date | 2021-11-29 00:00:00 | 2021-12-06 00:00:00 | 2021-12-13 00:00:00 | 2021-12-20 00:00:00 | 2021-12-27 00:00:00 | 2022-01-03 00:00:00 | 2022-01-10 00:00:00 | 2022-01-17 00:00:00 | 2022-01-24 00:00:00 | 2022-01-31 00:00:00 | 2022-02-07 00:00:00 | 2022-02-14 00:00:00
House 1 | 130 | 2021-01-10 00:00:00
House 2 | 400 | 2021-12-20 00:00:00
House 3 | 320 | 2021-01-17 00:00:00
Spreadsheet: 808349d1670425504-fraction-vs-decimal-vlookup-approximate-copy-of-measurement-conversion-question
Sheet: Measurement Conversion Question

 |  |  |  |  |  |  | 0.03125 | 0.03125
 |  |  |  |  |  |  | 0.0625 | 0.0625
 |  |  |  |  |  |  | 0.09375 | 0.09375
 |  |  |  |  |  |  | 0.125 | 0.125
 |  |  |  |  |  |  | 0.15625 | 0.15625
 |  | INTEGER | DECIMAL | MEASUREMENT TO CLOSEST 32ND | CORRECT RETURN VALUE |  | 0.1875 | 0.1875
 | 238.147375 |  |  |  | 0.15625 |  | 0.21875 | 0.21875
 | 238.27635 |  |  |  | 0.28125 |  | 0.25 | 0.25
 | 238 |  |  |  | 0 |  | 0.28125 | 0.28125
 | 238.7815 |  |  |  | 0.8125 |  | 0.3125 | 0.3125
 | 238.834 |  |  |  | 0.84375 |  | 0.34375 | 0.34375
 | 238.999 |  |  |  | ADDITION OF 1 TO INTEGER |  | 0.375 | 0.375
 | 238.125 |  |  |  | 0.125 |  | 0.40625 | 0.40625
 | 238.456 |  |  |  | 0.46875 |  | 0.4375 | 0.4375
 | 238.334 |  |  |  | 0.34375 |  | 0.46875 | 0.46875
 | 238.001 |  |  |  | 0.03125 |  | 0.5 | 0.5
 |  |  |  |  |  |  | 0.53125 | 17/32
 |  |  |  |  |  |  | 0.5625 | 0.5625
 |  |  |  | RETURN VALUE NEEDED |  |  | 0.59375 | 0.59375
 |  |  |  | COMPARITIVE VALUE |  |  | 0.625 | 0.625
 |  |  |  |  |  |  | 0.65625 | 0.65625
 |  |  | RETURN VALUE IN COLUMN E10 THRU E19 TO RETURN CLOSEST DECIMAL CONVERSION TO AMERICAN STANDARD MEASUREMENT >/= ROUNDED TO CLOSES 1/32 |  |  |  | 0.6875 | 0.6875
 |  |  |  |  |  |  | 0.71875 | 0.71875
 |  |  |  |  |  |  | 0.75 | 0.75
 |  |  |  |  |  |  | 0.78125 | 0.78125
 |  |  |  |  |  |  | 0.8125 | 0.8125
 |  |  |  |  |  |  | 0.84375 | 0.84375
 |  |  |  |  |  |  | 0.875 | 0.875
 |  |  |  |  |  |  | 0.90625 | 0.90625
 |  |  |  |  |  |  | 0.875 | 0.875
 |  |  |  |  |  |  | 0.90625 | 0.90625
 |  |  |  |  |  |  | 0.9375 | 0.9375
 |  |  |  |  |  |  | 0.96875 | 31/32
Spreadsheet: 696905d1601034187-quantity-from-percentage-and-price-formula
Sheet: Sheet1

Quantity |  | Buying price | Paid | Ratio
0.25 |  | 5000 |  |  | 0.2
2000 | 2000 | 0.12 |  |  | 0.3
3 | 3 | 185 |  |  | 0.2
6 | 30 | 4.33 |  |  | 0.1
1200 | 1200 | 0.04 |  |  | 0.05
750 | 1000 | 0.007 |  |  | 0.05
1500 | 2000 | 0.007 |  |  | 0.05
3000 | 6000 | 0.035 |  |  | 0.05
500 | 500 | 0.025415 |  |  | 0
 |  |  | Invested
Spreadsheet: b4fcb368-a93d-4c80-86a4-8a0ba6a54c13
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
35838656 | 2013-05-07 23:06:19 | AXIS | 0 | 5 | 10 | 1229610 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35839284 | 2013-05-07 23:40:33 | AXIS | 1 | 10 | 6 | 1077170 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35853261 | 2013-05-08 23:15:18 | AXIS | 1 | 10 | 3 | 1075667 | player1075667 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35853754 | 2013-05-08 23:45:58 | ALLIES | 0 | 4 | 10 | 1075667 | player1075667 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35868292 | 2013-05-09 23:35:43 | AXIS | 1 | 10 | 7 | 1287131 | GROSS JL | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35883277 | 2013-05-11 00:31:15 | AXIS | 1 | 10 | 6 | 67493 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35894257 | 2013-05-11 17:45:16 | ALLIES | 0 | 3 | 6 | 418850 | SIR B LAW | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
35894500 | 2013-05-11 18:08:59 | AXIS | 1 | 6 | 5 | 418850 | SIR B LAW | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
35929813 | 2013-05-13 23:03:15 | AXIS | 0 | 9 | 10 | 538522 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35944280 | 2013-05-14 22:32:45 | AXIS | 0 | 5 | 10 | 1268060 | Borgo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35944765 | 2013-05-14 23:34:02 | ALLIES | 0 | 7 | 10 | 1268060 | Borgo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35959114 | 2013-05-15 23:20:54 | AXIS | 0 | 7 | 10 | 418850 | SIR B LAW | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35973073 | 2013-05-16 23:34:08 | AXIS | 1 | 10 | 6 | 67493 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35997010 | 2013-05-18 16:34:37 | AXIS | 0 | 3 | 10 | 251867 | Calgada | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
35997538 | 2013-05-18 17:25:14 | ALLIES | 0 | 4 | 10 | 506159 | hurletout | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
36034215 | 2013-05-20 22:55:30 | AXIS | 0 | 5 | 10 | 688270 | Mouchotte72 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
36034728 | 2013-05-20 23:25:29 | AXIS | 1 | 10 | 4 | 733011 | Jeanfederer | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
36049725 | 2013-05-21 23:52:05 | AXIS | 1 | 11 | 7 | 22730 | bhyman | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 67682d1268244922-excel-2007-how-to-add-only-positive-numbers-in-my-sumif-statement-test3-10
Sheet: Inventory

ModelName | ModelNumber |  | Description |  |  | SerialNumber | Qty Ordered | Qty Received | Qty On Hand
xyz | 1234 |  | THING |  |  | 456asd4561 | 1
ABC | 4567 |  | RADIO |  |  | 111AAA3333 | 1
CP200 | AAH50RDC9AA1 - CP200  UHF  4CH |  | UHF RADIO |  |  | 222SSS3333 | 1
COAX | LMR400 |  | COAX CABLING |  |  |  | 1000
BATTERY | [NAME] |  | Something that holds a charge |  |  |  | 15
Spreadsheet: 737816d1624619022-use-random-value-from-a-range-but-excluding-values-from-specific-cells-randbetween-query
Sheet: Rota

Officers | Monday | Tuesday | Wednesday | Thursday | Friday
Duty officer 1
Duty officer 2
Emergency cover
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: $ monographs totals

Total Monographs Expenditures by [NAME] FY10 and FY11
[NAME], Library Budget Only (No Endowments):
Acquisition Type | FY10 | FY11 | % change | % of total FY11 expend.
Approval plan
Kingston (Strand) | 149863.36 | 103206.32
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
Firm orders
Kingston | 165993.09 | 209393.57
[NAME] (pelf) | 76.5 | 462.78
CCE (ccef) | 13780.93 | 10237.42
Standing orders
Kingston | 27708.57 | 20841.37
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
TOTALS
Total Monograph Endowment Expenditures FY10 and FY11
Acquisition Type | FY10 | FY11 | % change | % of total FY11 expend.
Approval plan | 0 | 0 | 0
Kingston (Strand) | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
Firm orders
Kingston | 3459.51 | 4263.48
[NAME] (pelf) | 0 | 0 | 0
CCE (ccef) | 0 | 0 | 0
Standing orders
Kingston | 351.17 | 114.39
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
TOTALS
Total Monograph Expenditures (Including Endowments) FY10 and FY11:
University Libraries | FY10 | FY11 | % change | % of total FY11 expend.
Library budget (all branches) |  | 344141.46
Endowments |  | 4377.87
TOTALS
Spreadsheet: 583494d1532460835-referencing-a-master-list-for-a-checklist-student-exercise-checklist-before
Sheet: Student #1

 |  | Done
 | x
Spreadsheet: 744979d1629632686-min-and-max-max-and-min-2-ans2
Sheet: Sheet1

Before :- |  |  |  |  | After :- |  |  | Country | Start | End |  | After :-
Country | Ref |  |  |  |  |  |  |  |  |  |  | Start | End
India | A1
Israel | B1
Hong Kong | C1
India | A2
Israel | B2
Hong Kong | C2
India | A3
Israel | B3
Hong Kong | [NAME]
India | A4
Israel | B4
Hong Kong | C4
India | A5
Israel | B5
Hong Kong | C5
Spreadsheet: 761118d1640660442-need-for-a-random-formula-that-generates-a-pre-determined-distribution-jerryong-random-excelforum
Sheet: Random Distribution

Emp ID | Rating | Allocation |  | Desired Rating Distribution
1 |  |  |  | 1
2 |  |  |  | 2
3 |  |  |  | 2
4 |  |  |  | 2
5 |  |  |  | 2
6 |  |  |  | 2
7 |  |  |  | 2
8 |  |  |  | 2
9 |  |  |  | 2
10 |  |  |  | 3
 | SUMMARY
 | Rating | Count | Percent
 | 1
 | 2
 | 3
COPY / PASTE FROM ABOVE WITH NO FORMULAS (THE ABOVE WILL BE DIFFERENT ONCE THIS FILE IS SAVED AND RE-OPENED)
Emp ID | Rating
1 | 3
2 | 3
3 | 1
4 | 1
5 | 1
6 | 2
7 | 1
8 | 1
9 | 3
10 | 2
 | SUMMARY
 | Rating | Count | Percent
 | 1 | 5 | 0.5
 | 2 | 2 | 0.2
 | 3 | 3 | 0.3
 |  | 10 | 1
Spreadsheet: b0f24f8d-73b8-4267-a5ce-d1a885171ee9
Sheet: Sheet1

Travel Worksheet for Endeavor Presentation Award proposals | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Be sure to include an explanation of all expenses as a separate sheet
Travel
Category | Dates of travel | Cost per day or per mile | [NAME] or Days |  | Amount
Airfare*
USI Vehicle
Personal Vehicle
see USI vehicle rates at http://www.usi.edu/phyplant/rentalrates.asp
Lodging*
Hotel name | Dates of stay | Number of nights | Rate per night |  | Amount
Registration*
Organization | Dates of meeting | City | State |  | Amount
Per Diem
Cities | Departure date rate | Non traveling day rate | Return date rate | # of days | Amount
Miscellaneous (tolls, rental cars, cab fare, parking, etc. *)
Item Description |  |  |  |  | Amount
Total |  |  |  |  | 0
* subject to USI Travel Office rules and regulations
Spreadsheet: louise_kitchen__22547__schoolyard
Sheet: Sheet1

 |  |  |  | 1 | [NAME]
 |  |  |  | 2 | [NAME]
 |  |  |  | 3 | presto
 |  |  |  | 4 | shively
 |  |  |  | 5 | sturm
 |  |  |  | 6 | swerzbin
 |  |  |  | 7 | [NAME], [NAME]
 |  |  |  | 8 | [NAME]
 |  |  |  | 9 | zufferli
 |  |  |  | 10 | calger
 |  |  |  | 11 | milnthorp
 |  |  |  | 12 | herdon
 |  |  |  | 13 | motley
 |  |  |  | 14 | davies, derek
 |  |  |  | 15 | martin
 |  |  |  | 16 | grigsby
 |  |  |  | 17 | tycholiz
 |  |  |  | 18 | richter
 |  |  |  | 19 | luce
 |  |  |  | 20 | black
 |  |  |  | 21 | allen - would be much higher if he wasn't leaving in a year
 |  |  |  | 22 | devries
 |  |  |  | 23 | wiggs
 |  |  |  | 24 | duran
 |  |  |  | 25 | storey
 |  |  |  | 26 | zipper
 |  |  |  | 27 | [NAME]
 |  |  |  | 28 | ermis,frank
 |  |  |  | 29 | gonzalas,  orlando
 |  |  |  | 30 | aucoin
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner1

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner1
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-05 00:00:00 | MGT61102 | Tutor 1 | Video recording uploaded onto blackboard |  |  | PS to link
2023-09-06 00:00:00 | MGT61102 | Tutor 2 | Resources on blackboard |  |  | PS to complete
2023-09-11 00:00:00 | MGT61100 | [NAME] | (tutor to complete) |  |  | tutor to complete
Spreadsheet: 477166d1472154150-return-last-column-with-data-from-a-range-of-rows-excel-forum-sample-data
Sheet: Sheet1

Customer Name | Trasaction Type | 2013-01-25 00:00:00 | 2013-02-25 00:00:00 | 2013-03-25 00:00:00 | 2013-04-25 00:00:00 | 2013-05-25 00:00:00
ABC Corp | 1-Principal
 | 2-Payment |  |  | 155000
 | 3-Fees |  |  |  | 1020
 | 4-Interest |  | 120000 |  | 2000 | 145000
XYZ Corp | 1-Principal
 | 2-Payment |  |  | 42150
 | 3-Fees | 700 | 720 | 650 | 720
 | 4-Interest | 38000 |  | 90450
 | 5-Taxes | 45
Spreadsheet: 782971d1654494671-search-closest-match-in-one-column-sample-closest-value
Sheet: Sheet1

Name | Value A | Value B | The Closest Match
A1 | 1.01 | 100.4
T2 | 2.21 | 120.3 | S2
R1 | 1.08 | 200.2
BC1 | 3.21 | 99.56
S2 | 2.98 | 115.5 | T2
Spreadsheet: 66899d1267573663-conditional-unique-values-accounts
Sheet: Current Formulas

Accounts | Totals
1480-15 | 4962.24
9101-01 | 109.22 |  |  | This sheet | 87937.68000000001
2615-01 | 78000
1480-01 | 4000 |  |  | Data sheet | 87937.68000000001
1480-02 | 800
1480-03 | 66.22 |  |  | Difference | 0
 |  |  | My end result is that I will always have an automated account list with totals.
Spreadsheet: 190969d1351865432-filling-right-across-multiple-intervals-sales-mahju
Sheet: Sheet1

 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  | year 1 |  |  |  |  |  |  |  |  |  |  |  | year 2 |  |  |  |  |  |  |  |  |  |  |  | year 3
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Sales 1 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400 | 2500 | 2600 | 2700 | 2800 | 2900 | 3000 | 3100 | 3200 | 3300 | 3400 | 3500 | 3600
 | Sales 2 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
 | Sales 3 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300 | 310 | 320 | 330 | 340 | 350 | 360
 |  | Year 1 | Year 2 | Year 3
 | Sales 1 | 7800 | 22200 | 36600
 | Sales 2
 | Sales 3
Spreadsheet: 141559d1329330149-combine-two-worksheet-with-common-column-values-dummy-books-for-excel-help
Sheet: Sheet2

ccode | scode | country | year | fragment | democ | autoc | polity | polity2 | durable
255 | GMY | Germany | 1918 |  | -88 | -88 | -88 | 4 | 0
255 | GMY | Germany | 1919 |  | 6 | 0 | 6 | 6 | 0
255 | GMY | Germany | 1920 |  | 6 | 0 | 6 | 6 | 1
255 | GMY | Germany | 1921 |  | 6 | 0 | 6 | 6 | 2
255 | GMY | Germany | 1922 |  | 6 | 0 | 6 | 6 | 3
255 | GMY | Germany | 1923 |  | 6 | 0 | 6 | 6 | 4
255 | GMY | Germany | 1924 |  | 6 | 0 | 6 | 6 | 5
255 | GMY | Germany | 1925 |  | 6 | 0 | 6 | 6 | 6
255 | GMY | Germany | 1926 |  | 6 | 0 | 6 | 6 | 7
255 | GMY | Germany | 1927 |  | 6 | 0 | 6 | 6 | 8
255 | GMY | Germany | 1928 |  | 6 | 0 | 6 | 6 | 9
Spreadsheet: kate_symes__18466__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-17 00:00:00 |  | 235 | 160 | 150.91 | 880
 | 2001-01-16 00:00:00 |  | 174.75 | 640 | 114.61 | 1264 | 198.32 | 1393 | 118.67 | 961
 | 2001-01-15 00:00:00 |  | 174.29 | 560 | 114.61 | 1264 | 163.34 | 2155 | 121.91 | 913
 | 2001-01-14 00:00:00 |  | 135 | 160 | 102.1 | 496 | 151.06 | 2920 | 119.25 | 1375
 | 2001-01-13 00:00:00 |  | 170 | 160 | 116.65 | 1696 | 149.38 | 3307 | 112.78 | 1208
 | 2001-01-12 00:00:00 |  | 167.65 | 544 | 116 | 2136 | 146.77 | 361 | 110.31 | 1207
 | 2001-01-11 00:00:00 |  | 159.09 | 704 | 116 | 2136 | 147.18 | 1708 | 100.51 | 774
 | 2001-01-10 00:00:00 |  | 150 | 960 | 94.32 | 2280 | 140.57 | 584 | 101.31 | 555
 | 2001-01-09 00:00:00 |  | 127.81 | 1024 | 77.19 | 912 | 156.86 | 390 | 88.91 | 1464
 | 2001-01-08 00:00:00 |  | 132.55 | 1024 | 76.1 | 912 | 127.42 | 1330 | 71.95 | 583
 | 2001-01-07 00:00:00 |  | 115 | 0 | 62.5 | 0 | 63.78 | 2249 | 57.2 | 1278
 | 2001-01-06 00:00:00 |  | 124.17 | 384 | 93.8 | 432 | 102.76 | 521 | 66.24 | 647
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528 | 129.45 | 1527 | 123.46 | 455
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
Spreadsheet: 525313d1498664688-index-and-match-duplicates-sample
Sheet: Sheet1

DATE | CARRIER | CONTACT | PHONE | [NAME] | SHIP FROM | METHOD OF SHIP | location 1 | location 2 | location 2
2017-05-01 00:00:00 | CARRIER 1 | [NAME] smith | [PHONE] |  | host | FULL TRUCK | 4000 | 775 | 850
2017-04-26 00:00:00 | CARRIER 2 | [NAME] smith | [PHONE] |  | host | FULL TRUCK | 4000 | 775 | 1025
2016-11-11 00:00:00 | CARRIER 3 | [NAME] smith | [PHONE] |  | host | FULL TRUCK | 4165 | 845 | 780
2016-02-11 00:00:00 | CARRIER 4 | [NAME] smith | [PHONE] |  | host | FULL TRUCK | 4270 | 850 | 850
2017-05-08 00:00:00 | CARRIER 5 | [NAME] smith | [PHONE] |  | host | FULL TRUCK | 4275 | 845 | 850
2016-04-07 00:00:00 | CARRIER 6 | [NAME] smith | [PHONE] |  | host | FULL TRUCK | 4290 | 1077 | 925
2016-02-10 00:00:00 | CARRIER 7 | [NAME] smith | [PHONE] |  | host | FULL TRUCK | 4075 | 850 | 850
LOCATION 1:
1
2
3
Spreadsheet: 33948d1230911426-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-later-version-of-excel-revised
Sheet: Hours Worked By Month

Employee | 2003-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2006-01-01 00:00:00 |  |  |  |  |  | 2006-07-01 00:00:00 |  |  |  |  |  | 2007-01-01 00:00:00 |  |  |  |  |  | 2007-07-01 00:00:00 |  |  |  |  |  | 2007-01-01 00:00:00 |  |  |  |  |  | 2007-07-01 00:00:00 |  |  |  |  |  | 2008-01-01 00:00:00 |  |  |  |  |  | 2008-07-01 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160
Spreadsheet: 682211d1591966063-sum-based-on-order-number-in
Sheet: Sheet3

Invoice Number | Expr1 | WON | [NAME]
4420 | 100000 | 203363 | 2020-05-20 00:00:00
4421 | 1710 | 203398 | 2020-05-21 00:00:00
4422 | 2592.900146484375 | 203392 | 2020-05-21 00:00:00
4423 | 1845 | 203371 | 2020-05-21 00:00:00
4424 | 55898.64013671875 | 203323 | 2020-06-03 00:00:00
4425 | 5850 | 203361 | 2020-05-27 00:00:00
4426 | 7320 | 203358 | 2020-05-27 00:00:00
4427 | 6132 | 203240
 | TOTAL
Spreadsheet: 5c22b990-d13e-49ee-9a46-b4422d5c03a5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2012-2013 Unit Program Planner
ONLY ENTER DATA IN HIGHLIGHTED SPACES
1. Enter all your activities and costs per Scout under each month. |  |  | Unit Type and Unit # |  | Pack 38
2. Enter your number of Scouts and unit commission %. |  |  | Number of Scouts in Unit |  | 60
3. Fill in the five shaded fields at the bottom of the sheet. |  |  | Unit Commission % |  | 0.37
September |  | October |  | November
Activities | Cost | Activities | Cost | Activities | Cost
Pack Carnival | 6 | Halloween Party | 3 | Pack Awards Meeting | 12
 |  | [NAME] | 8
Total Cost | 6 | Total Cost | 11 | Total Cost | 12
December |  | January |  | February
Activities | Cost | Activities | Cost | Activities | Cost
Holiday Party | 10 | Pinewood Derby/Pit Night | 3 | Game Night | 4
Total Cost | 10 | Total Cost | 3 | Total Cost | 4
March |  | April |  | May
Activities | Cost | Activities | Cost | Activities | Cost
Blue & Gold Banquet | 42 | Bowling | 6 | Memorial Day Parade | 2
 |  |  |  | [NAME] | 5
Total Cost | 42 | Total Cost | 6 | Total Cost | 7
June |  | July |  | August
Activities | Cost | Activities | Cost | Activities | Cost
Graduation Camping | 20 | Pool Party | 8 | Summer Picnic | 8
Total Cost | 20 | Total Cost | 8 | Total Cost | 8
15 | Registration & Insurance |  | Unit Total Activity Cost & Expenses |  | 9840
12 | Boys' Life |  | Scout Total Activity Cost & Expenses |  | 164
0 | Uniform |  | Other Expenses |  | 0
0 | Advancements |  | Unit [NAME] |  | 26594.59459459459
27 | Total Expenses |  | Scout Sales Goal |  | 443.2432432432432
 |  |  | Unit Commission |  | 9840