tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18307__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-17 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832
 | 2001-04-16 00:00:00 |  | 379.99 | 21296 | 356.66 | 8480 | 359.26 | 135 | 202.5 | 100
 | 2001-04-15 00:00:00 |  | 368.33 | 1200 | 350 | 0 | 400 | 50 | 325 | 25 |  | 357.42 | 27864
 | 2001-04-14 00:00:00 |  | 369.89 | 22096 | 344.35 | 6848 | 365.25 | 505 | 346 | 0
 | 2001-04-13 00:00:00 |  | 369.89 | 22096 | 343.87 | 6048 | 392.86 | 420 | 421.33 | 60
 | 2001-04-12 00:00:00 |  | 411.66 | 16160 | 376.19 | 5352 | 431.44 | 1740 | 339.62 | 419
 | 2001-04-11 00:00:00 |  | 386.02 | 10560 | 337.56 | 7552 | 391.16 | 540 | 372.42 | 291
 | 2001-04-10 00:00:00 |  | 379.15 | 19760 | 331.04 | 9192 | 398 | 621 | 337.4 | 615
 | 2001-04-09 00:00:00 |  | 311.43 | 19600 | 264.75 | 6584 | 334.15 | 437 | 337.5 | 100
 | 2001-04-08 00:00:00 |  | 273.75 | 1600 | 255 | 0 | 349.76 | 1330 | 342.22 | 135 |  | 264.68 | 20136
 | 2001-04-07 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 293.05 | 1559 | 279.89 | 435
 | 2001-04-06 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 290.88 | 400 | 227.31 | 325
 | 2001-04-05 00:00:00 |  | 348.81 | 22560 | 266.94 | 2480 | 259.38 | 200 | 158.94 | 610
 | 2001-04-04 00:00:00 |  | 314.36 | 18160 | 238.83 | 8040 | 307.45 | 455 | 246.52 | 460
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200 | 300.45 | 350 | 288.25 | 1310
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 | 2001-03-18 00:00:00 |  | 370 | 0 | 330 | 0 | 140.35 | 285 | 146.22 | 1255 |  | 343.75 | 22080
 |  |  |  |  |  | ..
Spreadsheet: 26503d1218650955-auto-sum-data-based-on-2-criteria-sample
Sheet: Sheet1

Company | Symbol | Number1 | Cost
X | AAA | 2 | 120000
X | AAA | 2 | 22456
Z | AAA | 2 | 15000
Z | AAA | 2 | 1210
X | BBB | 3 | 122
X | BBB | 3 | 3333
Z | BBB | 3 | 444
Z | BBB | 3 | 44444
Spreadsheet: 56323d1256496921-vlookup-countif-nest-test-shirt-count
Sheet: SIzes

 |  | Youth Medium -- | [NAME] -- | [NAME] -- | [NAME] -- | [NAME] -- | [NAME] -- | Adult 2X Large -- | [NAME] --
1 | 40
2 | 41
3 | 42
4 | 43
5 | 44
6 | 45
7 | 50
8 | 51
9 | 52
10 | 53
11 | 54
12 | 55
Spreadsheet: 40814d1239208955-long-if-and-statements-master
Sheet: Tool

 | FILL & EJECT REQUIREMENTS
 |  | FILL GUNS |  |  | QTY/CAV | TIP
 |  |  |  |  | 0 | 24mmØ x 50mm |  |  |  |  |  | T2 x 1000 | FINDLAY | 24mmØ x 25mm | 42mm
 |  | BARREL LENGTH (USABLE) |  |  | 50mm |  |  |  |  |  |  | T2 x 1000 | PORTLAND | 24mmØ x 50mm | 50mm
 |  |  |  |  |  |  |  |  |  |  |  | T2 x 1000 | TULLAHOMA | 24mmØ x 25mm | 42mm
 |  |  |  |  |  |  |  |  |  |  |  | U85 | FINDLAY | 24mmØ x 25mm | 42mm
 |  |  |  |  |  |  |  |  |  |  |  | U85 | PORTLAND | 24mmØ x 25mm | 42mm
 |  |  |  |  |  |  |  |  |  |  |  | U85 | TULLAHOMA | 24mmØ x 25mm | 42mm
 |  |  |  |  |  |  |  |  |  |  |  | K711 | FINDLAY | 24mmØ x 21mm | 50mm
 |  |  |  |  |  |  |  |  |  |  |  | K711 | FINDLAY MALE | 24mmØ x 75mm | 50mm
 |  |  |  |  |  |  |  |  |  |  |  | K711 | PORTLAND
 |  |  |  |  |  |  |  |  |  |  |  | K711 | TULLAHOMA MALE | 24mmØ x 75mm | 50mm
 |  |  |  |  |  |  |  |  |  |  |  | K1014 | FINDLAY MALE | 20mmØ x 21mm | 50mm
 |  |  |  |  |  |  |  |  |  |  |  | K1318 | PORTLAND | 35mm | 35mm
 |  |  |  |  |  |  |  |  |  |  |  | K13518 | MEXICO | 24mmØ x 50mm | 50mm
Spreadsheet: 72829d1273548840-count-how-often-multiple-number-values-occur-by-using-functions-audit-average-sample
Sheet: Audit Average Report

Business Unit | Region | Period | Project No. | Audit Score | Status
WAE | NSW | P1012 | EN02788 | 85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BIF | ASIA | P1012
WAE | NSW | P1012 | EN02789 | 83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MIN | CHI | P1013
BIF | SEA | P1012 | EN02790 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAE | EUR | P1101
BIF | SEA | P1012 | EN02791 | 45 |  |  | WHAT IM WANTING TO GET OUT OF THE TABLE |  |  |  |  |  |  |  |  |  |  |  | WAE | NSW | P1102
BIF | NSW | P1012 | EN02792 | 33 |  |  | Example: |  |  |  |  |  |  |  |  |  |  |  |  | NZ | P1103
BIF | WANT | P1012 | EN02793 | 85 |  |  | How many PAE projects in the NSW Region have a Red score |  |  |  |  |  |  |  |  |  |  |  |  | QLD | P1104
PAE | WANT | P1012 | EN02794 | 90 |  |  | How many PAE projects in QLD have a Green score |  |  |  |  |  |  |  |  |  |  |  |  | SEA | P1105
PAE | QLD | P1012 | EN02795 | 92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WANT | P1106
PAE | QLD | P1012 | EN02796 | 98 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1107
PAE | NSW | P1012 | EN02797 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1108
MIN | QLD | P1012 | EN02798 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1109
MIN | QLD | P1012 | EN02799 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1110
MIN | NSW | P1012 | EN02800 | 72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1112
BIF | SEA | P1012 | EN02801 | 98 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1113
BIF | ASIA | P1012 | EN02802 | 84
PAE | ASIA | P1012 | EN02803 | 86
PAE | NSW | P1012 | EN02804 | 45 |  |  | SAMPLE of the count if function im working on
 |  |  |  |  |  | = | count(if((a2:a15000="bif")*(b2:b15000="NSW")*(g2:g15000="Green"))
Spreadsheet: 764938d1643078596-sum-range-totals-in-a-date-range-where-range-does-not-match-criteria-hrs-calculation-example
Sheet: Sheet1

Instalment Frequency | Weekly
[NAME] | Quarterly
Start Date | 2022-01-01 00:00:00
End Date
Total
Instalment Start | 2022-01-01 00:00:00
 | Instalment Start | Instalment End | HRS | Repayment End Date |  | Helper? Dynamic Sum Range | Sum HRS Per Repayment Frequency |  |  | Wage Subsidy Period Start | Days Helper | Wage Subsidy Period End | Amount Payable
 |  |  | 20
 | 2022-01-08 00:00:00 | 2022-01-14 00:00:00 | 20 | 2022-07-01 00:00:00 |  | 20 | 0 |  |  | 2022-04-02 00:00:00 |  | 2022-07-01 00:00:00
 | 2022-01-15 00:00:00 | 2022-01-21 00:00:00 | 20 |  |  | 20
 | 2022-01-22 00:00:00 | 2022-01-28 00:00:00 | 20 |  |  | 20
 | 2022-01-29 00:00:00 | 2022-02-04 00:00:00 | 20 |  |  | 20
 | 2022-02-05 00:00:00 | 2022-02-11 00:00:00 | 20 |  |  | 20
 | 2022-02-12 00:00:00 | 2022-02-18 00:00:00 | 20 |  |  | 20
 | 2022-02-19 00:00:00 | 2022-02-25 00:00:00 | 20 |  |  | 20
 | 2022-02-26 00:00:00 | 2022-03-04 00:00:00 | 20 |  |  | 20
 | 2022-03-05 00:00:00 | 2022-03-11 00:00:00 | 20 |  |  | 20
 | 2022-03-12 00:00:00 | 2022-03-18 00:00:00 | 20 |  |  | 20
 | 2022-03-19 00:00:00 | 2022-03-25 00:00:00 | 2 |  |  | 2
 | 2022-03-26 00:00:00 | 2022-04-01 00:00:00 | 10 |  |  | 10
 | 2022-04-02 00:00:00 | 2022-04-08 00:00:00 | 15 |  |  | 15
 | 2022-04-09 00:00:00 | 2022-04-15 00:00:00 | 20 |  |  | 20
 | 2022-04-16 00:00:00 | 2022-04-22 00:00:00 | 20 |  |  | 20
 | 2022-04-23 00:00:00 | 2022-04-29 00:00:00 | 5 |  |  | 5
 | 2022-04-30 00:00:00 | 2022-05-06 00:00:00 | 5 |  |  | 5
 | 2022-05-07 00:00:00 | 2022-05-13 00:00:00 | 8 |  |  | 8
 | 2022-05-14 00:00:00 | 2022-05-20 00:00:00 | 6 |  |  | 6
 | 2022-05-21 00:00:00 | 2022-05-27 00:00:00 | 6 |  |  | 6
 | 2022-05-28 00:00:00 | 2022-06-03 00:00:00 | 15 |  |  | 15
 | 2022-06-04 00:00:00 | 2022-06-10 00:00:00 | 0 |  |  | 0
 | 2022-06-11 00:00:00 | 2022-06-17 00:00:00 | 0 |  |  | 0
 | 2022-06-18 00:00:00 | 2022-06-24 00:00:00 | 0 |  |  | 0
 | 2022-06-25 00:00:00 | 2022-07-01 00:00:00 | 0 |  |  | 0
Spreadsheet: 0f6c850d-1ebb-4629-b287-09ce38ef1c44
Sheet: SY 13-14 Price Calculator

 | SY 2013-2014 Weighted Average Price Calculator
 | Enter current prices and number of lunches sold at each price using October 2013 data.
 | Monthly # of Paid Lunches | Paid Lunch Price | Monthly Revenue | SY 2013-14 Weighted Average Price
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
TOTAL |  |  |  |  | is the SY2013-14 Weighted Average Price
 |  |  | Rounded Weighted Avg Price
 |  |  |  |  |  | Enter this price in the first data entry box on the SY14-15 NonFederal Calculator
 | Click to go back to SY 14-15 Non-Federal Calculator |  |  |  |  | Go to instructions
Note:  This tool is created to allow the user to only enter the number of paid lunches and the related prices.  If any other parts of the tool are modified, the user runs the risk of calculating an incorrect new average price.  [NAME] should not modify the tool's current functionality.
Spreadsheet: 97fb55c2-4bb3-4a1a-896b-d813adfcd8c4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  | Planet Footprint - Anomaly Report
 |  |  | All accounts that have anomalies for Anywhere Council.
 |  | This report shows all of your organisation's accounts that have anomalies.
 |  | Anomalies are sorted in descending order with the largest anomalies at the top.  By working top-down through each section you will address the largest and most important anomalies first.
 |  | You are then able to provide explanations as to why these anomalies have occurred and indicate any action that was (or should be) taken to rectify the anomaly or prevent it from occurring again.
 |  | If you have responsibilities defined for each account, Planet Footprint can provide a separate report for each responsible person or role.  This report shows all anomalies, regardless of whether the account has a responsibility assigned.
 |  | For further information on how to use anomaly reports, please visit: |  |  |  |  |  |  | http://www.planetfootprint.com/subscribers/support/Quick-Guides/Anomalies-Overview
 |  | What you can do: |  |  |  | (Click blue links to go directly to the sheet you want to work on.)
 |  | 1. |  | View Anomaly Report - Electricity |  |  | Sheet 2 | View anomalies for all of your organisation's electricity accounts
 |  | 2. |  | View Anomaly Report - Mains and Bottled Gas |  |  | Sheet 3 | View anomalies for all of your organisation's gas accounts
 |  | 3. |  | View Anomaly Report - Water |  |  | Sheet 4 | View anomalies for all of your organisation's water accounts
 |  | Once completed, save the Excel workbook (File - Save) and email it to [EMAIL]
 |  |  | Issued on 24 Jul 2009 for Anywhere Council.
 |  |  | © 2009 Planet Footprint Pty Ltd
Spreadsheet: 858843d1707366553-addition-of-points-that-meet-certain-conditions-x-country-results-sheet-2
Sheet: Points

 |  | PARTICIPATION POINTS
 |  | Give 1 point for each competitor
 |  | Tibro | Coochin | Coonowrin
Preps |  | 2 | 4 | 4
Yr 1 |  | 3 | 3 | 3 |  |  |  | Tibro | Coochin | Coonowrin
Yr 2 |  | 4 | 2 | 4 |  |  | TOTAL
Yr 3 |  | 3 | 1 | 5
Yr 4 |  | 2 | 3 | 4
Yr 5 |  | 3 | 3 | 4
Yr 6 |  | 4 | 1 | 5 |  |  | CHAMPIONS | ? | I want this to automatically populate with the largest score from above and display the name and not the score.
 | Total |  |  |  |  |  | RUNNER UP | ? | For example with the above data the champion would be Coonowrin and [NAME] Up is Tibro
 |  | Tibro | Coochin | Coonowrin
BOYS |  | 12 | 13 | 32
GIRLS |  | 12 | 11 | 21
Spreadsheet: 834711d1688027169-require-help-in-multiple-vlookup-tasl-pan-india-dispatch-report-working
Sheet: WB.GJ.Details

State | Store | Variety | Total Bags | Dis.Qty | Dest. Plant | Dis. Date | Vehicle No | Driver Number | UC | TPOD | Solid | Rebates % | Accp/Rej | GRN Qty | [NAME]. | Tertiary Cust. | Status |  | Reporting Date | Reporting time | Unloading date | Status | Transit days | Halting at Plant
WB | MMMCCL |  |  |  |  | 2023-06-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-28 00:00:00
WB | SGS
WB | NB
WB | SGS
WB | NB
WB | SGS
WB | NB
WB | MMMCCL
Spreadsheet: 673430d1587386396-calculate-total-hours-that-fall-between-a-specific-time-period-over-midnight-time_fall_2
Sheet: Sheet1

 |  | lower | 00:00:00 | 06:00:00 | 14:00:00 | 22:00:00 | 1 day, 6:00:00
 |  | upper | 06:00:00 | 14:00:00 | 22:00:00 | 1900-01-01 06:00:00 | 1900-01-01 14:00:00
 | time in | time out |  |  |  |  |  | Night Shift | Early Shift | Lates
formula 1 | 22:00:00 | 05:00:00
 | 03:00:00 | 11:00:00
Spreadsheet: chris_germany__1884__tp2_ticketsJun2001
Sheet: price_calc

june
 | Receipt |  |  |  |  |  |  | Delivery
 | Volume | Price |  |  | Comm | Fuel |  | Volume | Price |  | Variable
 | 3000 | 3.74 |  | [NAME] FT |  |  |  |  |  |  |  |  |  |  |  | IT Comm | Del Price
 | 0 | 4.835 |  | Ela - Mamou |  | 1
 |  |  |  |  |  |  |  |  |  |  | Ela | [NAME] | Stx | M1
 | 700 | 3.945 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 0.1322
 | 5000 | 3.695 |  | Wla - M2
 | 5485 | 3.65 |  | [NAME] | 0.0919
 | 2600 | 3.785 |  | M1 - M2 | 0.0615
 | 5000 |  |  | [NAME] | 0.1016 |  |  |  |  |  |  |  |  |  |  | 0.1522
 | 434 |  |  | [NAME] | 0.1047
 | 4000 |  |  | [NAME] | 0.1118
 | 10000 |  |  | M1 - M3 | 0.0814
 | 0 |  |  | [NAME]
 | 0 |  |  | [NAME]
 | 0 |  |  | [NAME]
Transco
 | Excludes Surcharges
 | Includes surcharges  ACA = $[NAME], GRI = $.0070, GP = $[NAME] |  |  |  |  |  |  |  |  |  | Z3 | Z4 | Z6
 | 0 | 4.4 |  | Z1 - Z6
 | 0 | 4.415 |  | [NAME]
 | 6081 | 3.94 |  | [NAME]
 | 5649 | 4.473 |  | [NAME]
 | 0 | 4.646 |  | [NAME]
 | 0 | 5.155 |  | [NAME]
 | 0 | 5.155 |  | Z1 - Z3
 | 0 | 5.155 |  | Z2 - Z3 | 0.0066
 | 0 | 4.2158 |  | Z3 - Z3 | 0.0035
 | 0 | 5.155 |  | Z4 - 3 Bhaul | 0.017 | 1
 | [NAME] => | 4.497 |  | [NAME] |  | <= Z5 Price
 |  |  |  | [NAME]
[NAME] Emporia
Zone 3 | 0 | 3.93 |  | Z3 - Z5
CGAS [NAME] |  |  |  | Disc Fuel
Cgas Pool |  | 4.1 |  | Reg fuel
 |  |  |  |  |  |  |  |  |  |  | 4.095
Sheet 40 E capacity
 | 5144 | 4.08 |  | Niag-Leidy
 | 5041 |  |  | Leidy - Z6 |  |  |  |  |  |  | 4.14
 | 500 |  |  | Leidy - Z6
 |  | Variable 6-6
CGLF
 | 856 | 3.88 |  | On-Ml FT | 0.0039
 | 0 | 3.895 |  | ON-Ml IT | 0.0388
 | 0 |  |  | Ml-Leach FT | 0.0192
 | 0 | 3.95 |  | Ml-Leach FT | 0.0192
Spreadsheet: 861545d1709421364-populate-an-amount-into-the-correct-column-based-on-a-weekly-paycheck-test-budget-formulas
Sheet: Sheet1

 |  |  | PayDay >>>> | 2024-03-08 00:00:00 | 2024-03-15 00:00:00 | 2024-03-22 00:00:00 | 2024-03-29 00:00:00 | 2024-04-05 00:00:00
 | expense | amount | due date
 | donation | 256.54 | weekly |  |  |  |  |  |  |  |  |  | 256.54 | 256.54 | 256.54 | 256.54 | 256.54
 | Best Egg | 428.11 | 8th |  |  |  |  |  |  |  |  |  | 428.11 |  |  |  | 428.11
 | IRS | 400 | 12th |  |  |  |  |  |  |  |  |  | 400
 | Mortgage | 4000 | 1st |  |  |  |  |  |  |  |  |  |  |  |  | 4000
 | gas budget | 150 | weekly |  |  |  |  |  |  |  |  |  | 150 | 150 | 150 | 150 | 150
 | [NAME] | 60 | 1st |  |  |  |  |  |  |  |  |  |  |  |  | 49
 | Synchrony | 375 | 18th |  |  |  |  |  |  |  |  |  |  | 375
 | Kia lease | 311.9 | 5th |  |  |  |  |  |  |  |  |  |  |  |  |  | 311.9
 | Progressive | 437.77 | 5th |  |  |  |  |  |  |  |  |  |  |  |  |  | 570
 | Groceries | 350 | Weekly |  |  |  |  |  |  |  |  |  | 350 | 350 | 350 | 350 | 350
 |  |  | Total | 1584.65 | 1131.54 | 756.54 | 4805.54 | 2066.55
Spreadsheet: 883051d1731536363-trying-to-calculate-number-of-days-between-today-and-date-next-yeare-microsoft-surface-7
Sheet: Calc Per Pay Period

Projected |  |  |  |  |  | Actual Cash Saved
Date | Amount | Camera FTZ Memory Flash Through 4-25 | Camera FTZ Memory Through 3-28 | [NAME] Through 12-20 |  | Date | Amount | Camera FTZ Memory Flash | Camera FTZ Memory | [NAME] |  | Days to March 28
2024-11-08 00:00:00 |  |  |  |  |  | 2024-11-08 00:00:00
2024-11-14 00:00:00 | 1000 |  |  |  |  | 2024-11-14 00:00:00 | 1000
2024-11-22 00:00:00 | 360 |  |  |  |  | 2024-11-22 00:00:00
2024-12-06 00:00:00 | 360 |  |  |  |  | 2024-12-06 00:00:00
2024-12-20 00:00:00 | 360 |  |  |  |  | 2024-12-20 00:00:00
2025-01-03 00:00:00 | 360 |  |  |  |  | 2025-01-03 00:00:00
2025-01-17 00:00:00 | 360 |  |  |  |  | 2025-01-17 00:00:00
2025-01-31 00:00:00 | 360 |  |  |  |  | 2025-01-31 00:00:00
2025-02-14 00:00:00 | 360 |  |  |  |  | 2025-02-14 00:00:00
2025-02-28 00:00:00 | 360 |  |  |  |  | 2025-02-28 00:00:00
2025-03-14 00:00:00 | 360 |  |  |  |  | 2025-03-14 00:00:00
2025-03-28 00:00:00 | 360 |  |  |  |  | 2025-03-28 00:00:00
2025-04-11 00:00:00 | 360 |  |  |  |  | 2025-04-11 00:00:00
2025-04-25 00:00:00 | 360 |  |  |  |  | 2025-04-25 00:00:00
Spreadsheet: 822987d1679631905-listing-the-winner-s-of-a-golf-skin-in-separate-cell-golf
Sheet: SKIN

GOLFER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | HOLE # | GOLFER | SCORE
A | 4 | 6 | 6 |  |  |  | 5 | 4 | 5 | 5 | 5 | 4 | 5 | 5 | 4 | 5 | 4 | 5 |  | 1
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
Spreadsheet: 834158d1687494159-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-individual-2
Sheet: DOM

Example | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | Calculation method used for reference | Remarks
1 | DOM | 2022-07-11 00:00:00 |  | 60 |  | 2 |  | (15*E2)/30 | 15 is the rate as per date and load criteria in sheet DMR
2 | DOM | 2022-08-11 00:00:00 |  | 55 |  | 4.5 |  | (45*E3)/30 | 45 is the rate as per date and load criteria in sheet DMR
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: FN06 HKO

 |  |  |  |  | FN06 HKO
Registration number : | FN06 HKO |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | VAUXHALL |  | 2008-09-29 00:00:00 | 12 Months | 2009-10-01 00:00:00 | 120
Specification : | Van (2 Axle) |  | 2009-09-30 00:00:00 | 12 Months | 2010-10-01 00:00:00 | 125
Type : | ASTRA VAN |  | 2010-09-30 00:00:00 | 12 Months | 2011-10-01 00:00:00 | 125
1st Registered : | 10.03.06 |  | 2011-09-30 00:00:00 | 12 Months | 2012-10-01 00:00:00 | 130
Engine : | 1686 cc
[NAME] : | n/a
Back To Index
Spreadsheet: 120449d1315310862-can-this-be-done-with-lookup-test1
Sheet: Sheet1

File-1
Item Code | Qty Ordered
1001 | 50
1305 | 400
2300 | 25
4000 | 275
500 | 70
File-2
 | Code based on qty ordered
 | A1 | A2 | B2 | B3 | B5 | C1
Item Code
500 | 100 | 90 | 80 | 75 | 65 | 50
750 | 200 | 175 | 150 | 100 | 80 | 75
1001 | 40 | 50 | 90 | 100 | 150 | 200
1200 | 300 | 280 | 230 | 200 | 150 | 100
1305 | 400 | 350 | 300 | 200 | 220 | 200
2300 | 45 | 40 | 30 | 20 | 15 | 10
2500 | 90 | 75 | 65 | 45 | 35 | 25
4000 | 500 | 400 | 350 | 300 | 250 | 200
Output wanted (With third column automatically populated using formulae)
Item Code | Qty Ordered | Order Code (based on quantity ordered)
1001 | 50 | A2
1305 | 400 | A1
2300 | 350 | B3
4000 | 275 | B5
500 | 10 | B5
Spreadsheet: 117029d1312399950-tranposed-results-based-on-a-column-tigeravatar-example-workbook-for-pauliej
Sheet: Sheet1

HeaderA | HeaderB
A | 1 | 2 | 3
B | 1 | 2
C | 1 | 2 | 3 | 4
D | 1 | 2 | 3 | 4 | 5
E | 1 | 2 | 3
Spreadsheet: 732664d1621129185-possible-vlookup-function-trying-to-search-through-multiple-sheets-summary-v4
Sheet: Summary

PROJECT NUMBER | Crew mumbers | Crew Sup Days | Crew Sup OT HOURS | Camp Sup Days | Camp Sup OT Hours | CCV DAYS (C01) | CCV Miles (C01) | Support Vehicle DAYS | Support Vehicle Miles | Additional Saws | Chipper Days | FUEL REDUCTION ACRES | [NAME] | [NAME] | [NAME]
011
235
089A
089A
Spreadsheet: 538737d1505811268-adding-row-content-from-sheet-to-sheet-example
Sheet: Technical

 |  |  |  |  | Technical
 |  |  |  |  | 2017-09-19 00:00:00
 | Session # | 8
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 9
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 10
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 11
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 12
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 13
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 14
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 15
 | 1 | Technical |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
Spreadsheet: 35240d1232779414-vlookup-issue-again-datetest
Sheet: Sheet1

EXAMPLE
 |  |  |  |  |  |  | Monthly Listing
 | Name | Anniversary | Birthday |  |  | Month | Name | Anniversary | Birthday
 | [NAME] | 2004-01-09 00:00:00 | 1980-02-01 00:00:00 |  | >>>>> | January
 | [NAME] | 2002-01-02 00:00:00 | 1981-03-13 00:00:00
 | Jan | 2008-01-01 00:00:00 | 1972-01-03 00:00:00
 | [NAME] | 2001-01-23 00:00:00 | 1983-01-02 00:00:00
 | [NAME] | 2000-01-21 00:00:00 | 1977-03-03 00:00:00
 | [NAME] | 2001-02-14 00:00:00 | 1959-01-04 00:00:00
 | [NAME] | 2002-02-22 00:00:00 | 1974-03-02 00:00:00
 | Samantha | 2003-02-26 00:00:00 | 1982-02-13 00:00:00
 | Rebecca | 2007-02-01 00:00:00 | 1981-03-28 00:00:00
 | [NAME] | 2008-03-04 00:00:00 | 1959-02-09 00:00:00
 | Roe | 2002-03-01 00:00:00 | 1983-03-12 00:00:00
 | [NAME] | 2003-03-15 00:00:00 | 1956-03-21 00:00:00
 | Anna | 2005-03-03 00:00:00 | 1959-02-11 00:00:00
 | [NAME] | 2001-03-13 00:00:00 | 1981-03-19 00:00:00