tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 710475d1609004810-access-data-with-conditional-timeline-report-ans-2
Sheet: SP

Report
Date | Product | No. | Amount | Time | Customer | Amount Actual day | Accumulation | % Complete
2020-12-01 00:00:00 | Chocolate cake | 3616100 | 100000 | Ca 1 | Thanh cong | 10000
2020-12-01 00:00:00 | Chocolate cake | 3616100 | 100000 | [NAME] | Thanh cong | 20000
2020-12-01 00:00:00 | Chocolate cake | 3616100 | 100000 | Ca 3 | Thanh cong | 50000
2020-12-01 00:00:00 | Huong cake | 3616101 | 50000 | [NAME] | The Sun | 12100
2020-12-01 00:00:00 | Huong cake | 3616101 | 50000 | Ca 3 | The Sun | 25100
2020-12-02 00:00:00 | Custas cake | 3616102 | 100000 | Ca 1 | Thanh cong | 15000
2020-12-02 00:00:00 | Custas cake | 3616102 | 100000 | [NAME] | Thanh cong | 10000
2020-12-02 00:00:00 | Custas cake | 3616102 | 100000 | Ca 3 | Thanh cong | 12000
2020-12-03 00:00:00 | Chocolate cake | 3616100 | 100000 | Ca 1 | Thanh cong | 5000
2020-12-03 00:00:00 | Chocolate cake | 3616100 | 100000 | [NAME] | Thanh cong | 10000
2020-12-03 00:00:00 | Chocolate cake | 3616100 | 100000 | Ca 3 | Thanh cong | 15000
2020-12-04 00:00:00 | Custas cake | 3616102 | 100000 | Ca 1 | Thanh cong | 6000
2020-12-04 00:00:00 | Custas cake | 3616102 | 100000 | [NAME] | Thanh cong | 4000
2020-12-04 00:00:00 | Custas cake | 3616102 | 100000 | Ca 3 | Thanh cong | 5000
2020-12-04 00:00:00 | Huong cake | 3616101 | 50000 | [NAME] | The Sun | 4000
2020-12-04 00:00:00 | Huong cake | 3616101 | 50000 | Ca 3 | The Sun | 9000
Spreadsheet: 180361d1347568233-excel-bar-graph-bar-graph-help
Sheet: Sheet1

Age | Leads | % of Total Leads | Quotes | % of Total Quotes
20 - 29 | 140 | 0.05998286203941731 | 8 | 0.01506591337099812
30 - 39 | 201 | 0.08611825192802057 | 12 | 0.02259887005649718
40 - 49 | 451 | 0.1932305055698372 | 69 | 0.1299435028248588
50 - 59 | 715 | 0.3063410454155955 | 152 | 0.2862523540489642
60 - 69 | 585 | 0.2506426735218509 | 193 | 0.3634651600753296
70 - 79 | 196 | 0.08397600685518423 | 72 | 0.1355932203389831
80+ | 46 | 0.01970865467009426 | 25 | 0.04708097928436911
Total | 2334 | 1 | 531 | 1
 |  |  |  |  | No female/male
80+
70 - 79
60 - 69
50 - 59
40 - 49
30 - 39
20 - 29
 |  | % of Total Leads | % of Total Quotes
 |  | 45, 35, 25, 15, 5, 0 | 0, 5, 15, 25, 35, 45
Spreadsheet: 122827d1317188684-need-help-in-developing-macros-20437-01-part3a
Sheet: Melbourne

BRANCH - MELBOURNE
[NAME] | January | Rate | Commission | Bonus | February | Rate | Commission | Bonus | March | Rate | Commission | Bonus | Grand Total
Gibbons, [NAME] | 2450 | 0 | 0 |  | 3680 | 0.03 | 110.4 |  | 3360 | 0.03 | 100.8 |  | 9701.199999999999
Gordon, Marie | 6750 | 0.105 | 742.5 |  | 7889 | 0.135 | 1341.13 | 1250 | 8745 | 0.15 | 1311.75 | 1250 | 29279.38
Knott, Delia | 5790 | 0.075 | 463.2 |  | 4987 | 0.06 | 299.22 |  | 4325 | 0.045 | 216.25 |  | 15617.47
Pascoe, [NAME] | 8890 | 0.15 | 1333.5 | 1250 | 9770 | 0.015 | 195.4 |  | 7988 | 0.135 | 1118.32 | 1250 | 31795.22
[NAME], [NAME] | 7988 | 0.135 | 1118.32 | 1250 | 8664 | 0.15 | 1299.6 | 1250 | 6950 | 0.105 | 764.5 |  | 29284.42
Stringer, [NAME] | 7680 | 0.12 | 921.5999999999999 | 1250 | 6995 | 0.105 | 769.45 |  | 5600 | 0.075 | 448 |  | 23664.05
Thompson, [NAME] | 4730 | 0.06 | 283.8 |  | 5450 | 0.075 | 436 |  | 6740 | 0.105 | 741.4 |  | 18097.4
Walters, [NAME] | 4765 | 0.06 | 285.9 |  | 6750 | 0.105 | 742.5 |  | 7420 | 0.12 | 890.4 | 1250 | 20567.9
Average | 6130.375 |  | 643.6025 |  | 6773.125 |  | 649.2125 |  | 6391 |  | 698.9274999999999 |  | 22250.88
Maximum | 8890 |  | 1333.5 |  | 9770 |  | 1341.13 |  | 8745 |  | 1311.75 |  | 31795.22
Minimum | 4730 |  | 283.8 |  | 4987 |  | 195.4 |  | 4325 |  | 216.25 |  | 15617.47
Monthly Total | 49043 |  | 5148.82 | 3750 | 54185 |  | 5193.7 | 2500 | 51128 |  | 5591.419999999999 | 3750 | 178007.04
Min, Max & Average not included in the N5 totals
Spreadsheet: 790359d1659669324-want-help-to-convert-a-number-to-binary-numbers-sample
Sheet: Sheet1

Raw data |  |  |  |  |  | formula goes in this column
Day number | deads |  |  |  | Day Number | Deads
2 | 5 |  |  |  | 2 | 1
3 | 3 |  |  |  | 2 | 1
4 | 10 |  |  |  | 2 | 1
5 | 14 |  |  |  | 2 | 1
6 | 6 |  |  |  | 2 | 1
 |  |  |  |  | 3 | 1
 |  |  |  |  | 3 | 1
 |  |  |  |  | 3 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | 4 | 1
 |  |  |  |  | and so on
Spreadsheet: 266242d1379542881-return-value-based-on-age-at-a-given-point-in-time-test-sheet
Sheet: test

Todays date
 | Name | DOB | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00
 | [NAME] bloggs | 2012-11-02 00:00:00 |  |  |  |  |  |  | 33
 | A Bloggs | 2013-06-15 00:00:00
 | Name | DOB | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00
 | [NAME] bloggs | 2012-11-02 00:00:00
 | A Bloggs | 2013-06-15 00:00:00
 | Lookup range
 | 0 | Orange
 | 2 | Blue
 | 3 | Red
 | 4.5 | Green
Spreadsheet: 35431d1233024219-lookup-first-three-instances-upload-example
Sheet: Excel Example

Total Min. | Pref. # |  | Type Pref # here
89 | 14866 |  | 14866
52 | 887
61 | 14866 |  | STDEV?
149 | 934
80 | 907
146 | 13259 |  | AVG?
116 | 13259
43 | 920
41 | 907 |  | MAX?
66 | 907
186 | 931
155 | 931
53 | 12616
114 | 877
65 | 907
69 | 14866
78 | 930
113 | 930
118 | 897
50 | 887
109 | 12664
72 | 897
56 | 907
108 | 930
73 | 14866
Spreadsheet: 45012d1243816393-if-valuea-appears-in-different-sheet-sum-valueb-with-conditions-exampleforsolving
Sheet: Sheet2

ID | LAST | FIRST | Div | Schl | In Research Register? | Points for 06 SR | Supported Researcher 2006 | Points for 07 SR | Supported Researcher 2007 | Points for 08 SR | Supported Researcher 2008 | # Principle Supervision | sum of Load = 1.0 | sum of Load = 0.5
000011 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000032 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000065 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000090 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000110 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000145 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000253 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000292 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000335 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000393 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000425 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000442 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000459 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000461 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000570 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000670 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000790 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000812 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000813 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000830 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000882 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000900 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000910 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000933 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
000978 |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS FORMULA IN HERE | NEEDS FORMULA IN HERE
001057
001090
001095
001120
001158
001286
001291
001292
001307
001327
001349
001360
001390
001394
001477
001511
001515
001584
001675
001724
001810
001850
001880
001890
001903
002050
002175
002234
002302
002312
002324
002359
002360
002373
002478
002591
002593
002620
002703
003050
003570
004250
005795
008290
008347
008729
008738
008968
009175
009226
009403
009594
010039
010075
010081
010082
010105
010152
010229
010266
010275
010278
010284
010285
010295
010298
010299
010301
010306
010307
010310
010313
010317
Spreadsheet: 2621cfc0-b3de-4c07-b915-dae0cd07fe13
Sheet: Sheet1

Deleted_Gene_Name | Responding to sPNAG
rfaP | -
rfaQ | -
rfaY | -
cbpM | +
dppC | +
[NAME] | +
gpp | +
[NAME] | +
hepA | +
hslR | +
kdtA | +
mutH | +
mutY | +
ilvD | +
nrfB | +
nrfD | +
[NAME] | +
rep | +
rfaB | +
rfaE | +
rfaF | +
rfaG | +
rfaI | +
rfaJ | +
rfaK | +
rfaS | +
rfaZ | +
rhlB | +
rtcR | +
yiaD | +
yicH | +
ydiR | +
yhhN | +
yhiQ | +
[NAME] | +
yjcQ | +
yraR | +
Spreadsheet: 677402d1589339432-averageifs-with-multiple-criteria-sample1234ab
Sheet: Sheet1

Type of Material | Quantities | Sales for 2018 | Sales for 2019
Silk | 20 | 456090 | 366322
Silk/Deim | 50 | 326555 | 890000
Cotton/Silk | 80 | 672222
Polyester | 30
Wool | 20 |  | 652300
Cotton/Wool | 60 | 35690
Criteria |  | [NAME]
Silk |  |  | ----> Array Formula
Silk/Deim
Cotton/Silk |  |  | ----> Non Array Formula
Spreadsheet: 748772d1632332918-create-a-daily-rolling-schedules-from-multiple-worksheets-daily-work-schedule
Sheet: Rack-Es Tab

Work Order | Work Scope | Status | Request date | Priority | Planner Comments
21-71466 | (FGD) 7-2 BLEED PUMP NEEDS NEW BELT INSTALLED | I-PROG |  | A-JR
21-71689 | 7 ABS 7-1 AR pump suction gate is leaking hydraulic fluid. It looks like it is coming from the top | I-PROG |  | A-JR | Sch later part of 4/12 work week
21-131398 | I&CS- troubleshoot 8-1 Oxidation Air Compressor | I-SCHD |  | A | IS THIS STILL A PROBLEM?
21-36406 | #1 coal yard run off sump pump is not pumping | P-PLAN |  | A | WMAT
21-50650 | Elec- Troubleshoot and repair U7 RR Sump | P-PLAN |  | A | WMAT
21-133783 | * ABS The quench line running from the quench pump to the duct work is leaking again. It is | P-PLAN |  | B | Moved to outage package
21-133787 | [NAME] eliminator recric valve 7WK109 is leaking around stem | P-PLAN |  | B | Moved to outage package
20-449748 | 7-3 AR Pump service water supply hose to gearbox is kinked. Needs hosed replaced | I-PROG |  | C
Spreadsheet: 134670d1325568725-counting-multiples-lead-breakdown
Sheet: Sheet2

Total # Of Companies
Convenience Stores / Gas Stations |  |  | Companies |  |  | [NAME] |  |  | Companies
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Restaurants - Full Serve / Casual Dining |  |  |  |  |  | [NAME]
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Restaurants - Quick Serve / Fast Food |  |  |  |  |  | [NAME]
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Retail - Big Box |  |  |  |  |  | [NAME]
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Retail - Grocery |  |  |  |  |  | [NAME]
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Retail - Medium Box |  |  |  |  |  | [NAME]
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Retail - Pharmacy |  |  |  |  |  | [NAME]
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Retail - Small Box |  |  |  |  |  | [NAME]
Open - Not Contacted |  |  |  |  |  | Open - Not Contacted
Actively Working |  |  |  |  |  | Actively Working
Nurturing |  |  |  |  |  | Nurturing
Unqualified |  |  |  |  |  | Unqualified
Spreadsheet: 757478d1638284282-income-tax-calculation-formula-turkey-income-tax-rates-2021
Sheet: vlookup

VLOOKUP METHOD
For taxable income over... | and not over... | Tax is... | plus... | of amount over...
0 |  |  | 0.15
24000 |  |  | 0.2
53000 |  |  | 0.27
190000 |  |  | 0.35
650000 |  |  | 0.4
Taxable Income |  | Total Tax (VLOOKUP) | Breakdown By Tax Bracket |  |  |  |  | Sum of Tax Brackets (check) | Net Income After Tax | Average Tax Rate | Top Tax Bracket
 |  |  |  | 0.2 | 0.27 | 0.35 | 0.4
15000
25000
55000
192000
330000
655000
660000
2500000
Spreadsheet: 84548d1284590260-graph-not-using-all-of-the-fields-i-select-graph-sample
Sheet: Yada

 | Yes | Yes | Yes | No | No | No | No | No | No | No | No | No | No
Function | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P13
Jumping Jacks | 95849 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Horseshoes | 3001482 |  |  | 2339510.88814 | 2339510.88814 | 2339510.88814 | 2339510.88814 | 2339510.88814 | 2339510.88814 | 2339510.88814 | 2339510.88814 | 2339510.88814 | 2339510.88814
[NAME] | 0 | 20582 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 951 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Closet | 4151 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total
Spreadsheet: 9f88f182-15b1-4483-9bb2-28d89f1f0a2b
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
42230496 | 2014-07-09 19:19:57 | AXIS | 0 | 2 | 4 | 377160 | docsteve | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42230950 | 2014-07-09 19:30:08 | ALLIES | 1 | 4 | 1 | 377160 | docsteve | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42273006 | 2014-07-12 20:37:40 | ALLIES | 1 | 6 | 3 | 632845 | [NAME] du Sud | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42273475 | 2014-07-12 20:56:05 | AXIS | 1 | 6 | 2 | 632845 | [NAME] du Sud | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42301535 | 2014-07-14 19:28:50 | AXIS | 0 | 4 | 6 | 1542223 | guy.warmoes | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42301884 | 2014-07-14 19:48:12 | ALLIES | 1 | 6 | 2 | 1542223 | guy.warmoes | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
Spreadsheet: 702911d1604602936-most-frequent-address-book1
Sheet: Sheet1

Excel Forum Example
Invoice No. | Address | Route | Codes | Freight Miles | [NAME] | [NAME] | [NAME] | Weight (lbs)
398020105714 | 3501 Roosevelt Blvd., Middletown, OH |  |  |  |  |  |  | 125
397358235299 | 1995 [NAME], Orange, CA |  |  |  |  |  |  | 150
397390358354 | 135 [NAME]. NW., Albuquerque, NM |  |  |  |  |  |  | 115
397358677973 | 13701 S. Alma Ave., Gardena, CA |  |  |  |  |  |  | 115
397357982242 | 13701 S. Alma Ave., Gardena, CA |  |  |  |  |  |  | 115
396883429790 | 3001 Bloomfield Hwy., Farmington, NW |  |  | 1645 |  |  |  | 220
396883550994 | 3215 Hwy 64, Waterflow, NM |  |  | 1653 |  |  |  | 220
396883671057 | 3001 Bloomfield Hwy., Farmington, NW |  |  | 1645 |  |  |  | 220
395740536532 | 5006 Timberlea Blvd., [NAME], ON |  |  |  |  |  |  | 765
395256316026 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 585
395052368905 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 180
394212196515 | 5-823 Corydon Ave., [NAME], MB |  |  | 1132 |  |  |  | 370
394629516721 | 821 Tyson Rd., [NAME], AL |  |  | 930 |  |  |  | 125
394849267033 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 1000
394629516721 | 821 Tyson Rd., [NAME], AL |  |  | 930 |  |  |  | 125
394212196515 | 5-823 Corydon Ave., [NAME], MB |  |  | 1132 |  |  |  | 370
7218880255 | 10828 [NAME], Dallas, TX |  |  | 1214 |  |  |  | 1225
392732394061 | 6970 Van Buren Blvd., [NAME], CA |  |  | 2340 |  |  |  | 100
393291958977 | 7746 S. Union Park Ave., Midvale, UT |  |  | 1752 |  |  |  | 100
394097276185 | 351 Steelcase Road West, [NAME], ON |  |  | 272 |  |  |  | 285
390467063620 | 1442 Cliveden Ave., Delta, BC |  |  | 2453 |  |  |  | 613
390917362253 | Missing |  |  | 0 |  |  |  | 0
7218880093 | 1700 Northridge NW., Walker, MI |  |  | 172 |  |  |  | 200
7218880196 | 1020-A Derita Rd., Concord, NC |  |  | 678 |  |  |  | 543
779073626737 | 1735 West Front St., Plainfield, NJ |  |  | 647 |  |  |  | 1010
390192722655 | 4000 Eastdale Circle, Montgomery, AL |  |  | 866 |  |  |  | 125
779653759736 | 12610 Interuban Ave S., Seattle, WA |  |  | 2330 |  |  |  | 500
779756829896 | 1020-A Derita Rd., Concord, NC |  |  | 678 |  |  |  | 543
39020058890 | 11720 Montana Ave., El Paso, TX |  |  | 1744 |  |  |  | 135
390468918559 | 75 Aventura Court, Mississauga, ON |  |  | 248 |  |  |  | 735
390560773618 | 4700 Broadmoor Ave. SE., Kentwood, MI |  |  | 124 |  |  |  | 115
779576698132 | 1045 Middlegate Rd., [NAME], ON |  |  | 255 |  |  |  | 880
779552101996 | 10701 Gateway Blvd. S., El Paso, TX |  |  | 1714 |  |  |  | 105
779663003194 | 3131 [NAME]., Columbus, GA |  |  | 833 |  |  |  | 975
390669947752 | 222 West Merchandise Mart, Chicago, IL |  |  | 300 |  |  |  | 420
Totals
Spreadsheet: 216499d1361793509-how-to-add-fixed-time-with-now-formula-raw-data
Sheet: raw

MM/DD/YYYY HH:MM | MM/DD/YYYY HH:MM | I want like color data
2013-02-20 07:15:00 | 2413-02-24 00:00:00
2013-02-20 07:15:00 | 2413-02-24 00:00:00 | if date time formate is something like this no problem M/D/YYYY H:MM
2013-02-20 07:15:00 | 2413-02-24 00:00:00
2013-02-20 13:53:00 | 2413-02-24 00:00:00
2013-02-20 13:53:00 | 2413-02-24 00:00:00
2013-02-20 13:53:00 | 2413-02-24 00:00:00
2013-02-20 14:56:00 | 2413-02-24 00:00:00
2013-02-20 14:56:00 | 2413-02-24 00:00:00
2013-02-20 14:56:00 | 2413-02-24 00:00:00
2013-02-22 01:24:00 | 2413-02-24 00:00:00
2013-02-22 01:24:00 | 2413-02-24 00:00:00
2013-02-22 12:43:00 | 2413-02-24 00:00:00
2013-02-22 12:43:00 | 2413-02-24 00:00:00
2013-02-22 12:43:00 | 2413-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00
2013-02-23 06:23:00 | 2413-02-24 00:00:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00
2013-02-24 00:07:00 | 2013-02-24 00:07:00
2013-02-24 00:16:00 | 2013-02-24 00:16:00
2013-02-24 00:16:00 | 2013-02-24 00:16:00
Spreadsheet: 169289d1342773142-creating-a-order-form-for-a-machine-hire-system-automated-pricing-calcs
Sheet: Automated Rates

NWPL
7 Day Charge Calcs
Weekend Usage box |  |  | Y | Means the system will charge for weekend use.
 |  |  | N | The system will not charge for weekend use.
 |  |  | Days | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  | Charge | 35 | 60 | 85 | 100 | 120 | 144 | 168
 |  |  | There after £24.00 per day
 |  |  | Days |  | 8 | 9 | 10
 |  |  | Charge |  | 192 | 216 | 240
Automated system check
Weekend Usage box ticked? |  |  |  | Y
Start Date |  |  |  | 2012-07-19 00:00:00
End Date |  |  |  | 2012-07-28 00:00:00
Number of days |  |  |  | 10
Number Of Weekends |  |  |  | 2
Total number of days Charge |  |  |  | 240
Weekend Charge 20% of £168.00 |  |  |  | 67.2
Total |  |  |  | 307.2
Spreadsheet: 864281d1711499837-year-keep-showing-as-1905-personal-budget
Sheet: Budget Planning

Budget Planing
 |  | Define starting year in Settings |  | 2024
 |  | Income
 |  | employment
 |  | side hustle
 |  | dividends
 |  | Enter Income Category…
 |  | Enter Income Category…
 |  | Enter Income Category…
 |  | Enter Income Category…
 |  | Enter Income Category…
 |  | Enter Income Category…
 |  | Enter Income Category…
 |  | Total
Spreadsheet: 0e2b0a84-1055-47d8-a146-7bc806eb96a2
Sheet: PEPSICO

ΑΝΑΨΥΚΤΙΚΑ PEPSICO
ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ. |  | ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ.
PEPSI |  |  | CLASSIC ΛΕΜΟΝΙ 232LT/20ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI COLA 1,5LT | [NAME] |  | CLASSIC ΓΚΑΖΟΖΑ 232LT/20ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI COLA 0,25ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | CLASSIC ΒΥΣΣΙΝΟ 232LT/20ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI COLA 0,25ML N.R.B. | ΚΙΒΩΤΙΑ |  | ΣΟΔΑ 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI COLA 0,33ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΤΟΝΙΚ 0,25LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI COLA 0,5ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΤΟΝΙΚ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI COLA LIGHT 1,5LT | [NAME] |  | ΤΟΝΙΚ 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI COLA LIGHT 0,25ML/20ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΗΒΗ FRUITEA ΦΡΑΟΥΛΑ | ΚΙΒΩΤΙΑ
PEPSI COLA LIGHT 0,33ML/24TEM | ΚΙΒΩΤΙΑ |  | ΧΥΜΟΙ
PEPSI COLA LIGHT 0,5ML/24TEM | ΚΙΒΩΤΙΑ |  | ΗΒΗ GO BLUE 0,25LT/27TEM | ΚΙΒΩΤΙΑ
PEPSI TWIST 1,5LT | [NAME] |  | ΗΒΗ GO RED 0,25LT/27TEM | ΚΙΒΩΤΙΑ
PEPSI TWIST 0,33ML/24TEM | ΚΙΒΩΤΙΑ |  | ΗΒΗ GO YELLOW 0,25LT/27TEM | ΚΙΒΩΤΙΑ
PEPSI TWIST 0,5ML/24TEM | ΚΙΒΩΤΙΑ |  | ΗΒΗ Φ.Χ. ΠΟΡΤΟΚΑΛΙ 0,25LT/27ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI ΜΑΧ 1,5LT | [NAME] |  | ΗΒΗ Π.Μ.Β. 0,25LT/27ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI ΜΑΧ 0,33ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΡΟΔΑΚΙΝΟ 0,25LT/27ΤΕΜ | ΚΙΒΩΤΙΑ
PEPSI ΜΑΧ 0,5ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΒΥΣΣΙΝΟ 0,25LT/27ΤΕΜ | ΚΙΒΩΤΙΑ
7UP |  |  | ΗΒΗ ΕΝΕRGY RED 0,25LT/27TEM | ΚΙΒΩΤΙΑ
7UP 1,5 LT | [NAME] |  | ΗΒΗ ΡΟΔΙ 0,25LT/27ΤΕΜ | ΚΙΒΩΤΙΑ
7UP 0,25ML N.R.B. | ΚΙΒΩΤΙΑ |  | HBH Φ.Χ. ΠΟΡΤΟΚΑΛΙ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
7UP 0,25ML/20TEM | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΑΝΑΝΑΣ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
7UP 0,33ML/24TEM | ΚΙΒΩΤΙΑ |  | ΗΒΗ Π.Μ.Β. 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
7UP 0,5ML/24TEM | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΡΟΔΑΚΙΝΟ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
ΗΒΗ |  |  | ΗΒΗ ΒΥΣΣΙΝΟ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
[NAME] 1,5LT | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΓΚΡΕΙΠΦΡΟΥΤ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
ΠΟΡΤΟΚΑΛΑΔΑ ΜΠΛΕ 0,25ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΕΝΕRGY BLUE 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
ΠΟΡΤΟΚΑΛΑΔΑ ΜΠΛΕ 0,33ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΕΝΕRGY RED 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
[NAME] 0,25 N.R.B. | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΡΟΔΙ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
[NAME] 0,25ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΜΠΑΝΑΝΑ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
[NAME] 0,33ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΗΒΗ ΛΕΜΟΝΙ 1LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
[NAME] 0,5ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | LIPTON
ΛΕΜΟΝΙΤΑ 1.5LT | [NAME] |  | LIPTON ΛΕΜΟΝΙ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ 0,25ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | LIPTON ΡΟΔΑΚΙΝΟ 0,33LT/24ΤΕΜ. | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ 0,25ML/24ΤΕΜ Ν.R.B. | ΚΙΒΩΤΙΑ |  | LIPTON RED 0,33LT/24ΤΕΜ. | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ 0,33ML/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | LIPTON GREEN ORANGE 0,33LT/24TEM | ΚΙΒΩΤΙΑ
ΛΕΜΟΝΙΤΑ 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | LIPTON GREEN 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
ΣΟΔΑ 0,25LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | LIPTON RED 0,5LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
ΣΟΔΑ 0,25LT Ν.R.B. | ΚΙΒΩΤΙΑ |  | LIPTON GREEN 0,5LT/12TEM | ΚΙΒΩΤΙΑ
ΣΟΔΑ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | LIPTON ΛΕΜΟΝΙ 0,5LT/12TEM | ΚΙΒΩΤΙΑ
CLASSIC ΠΟΡΤΟΚΑΛΙ 232LT/20ΤΕΜ | ΚΙΒΩΤΙΑ |  | LIPTON ΡΟΔΑΚΙΝΟ 0,5LT/12ΤΕΜ | ΚΙΒΩΤΙΑ
 |  |  | LIPTON GREEN MHΛΟ 0,5LT/12TEM | ΚΙΒΩΤΙΑ
Spreadsheet: 865486d1712574186-calculating-a-rebate-scheme-using-different-ranges-rebate-test
Sheet: Sheet1

 |  | £0 - £499,999 |  | £500,000 - £999,999 |  | £1,000,000 - 1,999,999 |  | £2,000,000 - £3,999,999 |  | £4,000,000 +
 |  | 499999 |  | 999999 |  | 1999999 |  | 3999999 |  | 4000000
Brexons Turnover Todate |  | [NAME] on Annual Spend |  |  |  |  |  |  |  |  |  | Rebate based on proposed percentages.
Year September - August | Turnover | 0.015 |  | 0.025 |  | 0.035 |  | 0.045 |  | 0.06
 |  | Tier Spend | [NAME] | Tier Spend | [NAME] | Tier Spend | [NAME] | Tier Spend | [NAME] | Tier Spend | [NAME]
Quarter 1 2024 | 0
Quarter 2 2024 | 2500000 | 499999 |  | 500000 |  | 1000000 |  | 500001 |  | 0
0 | 0.015
500000 | 0.025
1000000 | 0.035
2000000 | 0.045
4000000 | 0.06