tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1b71db9e-3b75-43db-b96f-49599cd8b76f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413927F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 124657d1318527688-excel-problem-interval-vlookupfees
Sheet: Sheet1

Age | Fee |  | Age | Fee | <<This is the Vlookup Table
3 | 20 |  | 0 | 20
7 | 50 |  | 5 | 50
15 | 50 |  | 20 | 200
77 | 300 |  | 45 | 300
43 | 200 |  | 120
Spreadsheet: 794809d1662329232-how-to-highlight-the-cells-using-a-formula-with-conditional-formatting-or-else-book1-steiny88-
Sheet: Test

Serial Number | Description |  |  | Serial # | Test 2 | Test 3 |  | Serial Number | Test1 | Test2 | Test3 | Green | Yellow | Red | Blue
75E395X | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test2
 | Test2
 | Test2
 | Test2
 | Test2
 | Test3
 | Test3
 | Test3
Subtotal
75E3A4M | Test2
 | Test2
 | Test2
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test3
 | Test3
 | Test3
 | Test3
 | Test3
Subtotal
75E3A4Y | Test2
 | Test2
 | Test2
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
 | Test1
Subtotal
75E3B6H | Test3
 | Test3
 | Test3
 | Test3
Subtotal
78B5C1A | Test2
 | Test3
 | Test3
 | Test3
Subtotal
Spreadsheet: 130106d1322065783-conditional-formatting-icon-sets-traffic-lights
Sheet: Sheet1

 | Company XXX
 |  | Budget | Actual | Visual
 | 2011-04-01 00:00:00 | 29.26037461822686 | 29.02543730377395
 | 2011-05-01 00:00:00 | 28.36414082711559 | 28.36414082711559
 | 2011-06-01 00:00:00 | 28.56815356749654 | 28.56815356749654
 | 2011-07-01 00:00:00 | 28.9306489093017 | 28.94923755866345
 | 2011-08-01 00:00:00 | 29.2516750250814 | 28.10055552101491
 | 2011-09-01 00:00:00 | 29.21448375738506 | 28.32778635516595
 | 2011-10-01 00:00:00 | 29.11345539672783 | 28.49571366076177
 | 2011-11-01 00:00:00 | 29.06927611642176 | 29.16479086292259
 | 2011-12-01 00:00:00 | 28.96563350513994 | 29.18524336118568
 | 2012-01-01 00:00:00 | 28.99359912776685 | 29.35053249772294
 | 2012-02-01 00:00:00 | 29.01867317921229 | 29.72570705596576
 | 2012-03-01 00:00:00 | 29.03154039008284 | 29.89798876258142
Spreadsheet: 714538d1611263254-reference-data-table-and-return-closest-date-after-on-today-excel-forums-test-workbook
Sheet: Project Go Live Dates

Project | Start Date
Project 1 | 2020-12-27 00:00:00
Project 2 | 2021-06-01 00:00:00
Project 3 | 2021-01-18 00:00:00
Project 3 | 2021-02-01 00:00:00
Project 3 | 2021-03-01 00:00:00
Project 4 | 2021-07-01 00:00:00
Project 4 | 2021-09-01 00:00:00
Project 5 | 2021-06-01 00:00:00
Project 5 | 2022-01-01 00:00:00
Project 6 | 2021-03-01 00:00:00
Project 7 | 2020-12-21 00:00:00
Project 7 | 2021-01-18 00:00:00
Project 7 | 2021-01-25 00:00:00
Project 7 | 2021-02-08 00:00:00
Project 7 | 2021-03-01 00:00:00
Project 7 | 2021-04-01 00:00:00
Project 7 | 2021-08-01 00:00:00
Project 8 | 2020-10-01 00:00:00
Project 9 | 2020-12-06 00:00:00
Project 9 | 2020-12-16 00:00:00
Project 9 | 2020-12-28 00:00:00
Project 9 | 2021-01-01 00:00:00
Project 10 | 2020-12-01 00:00:00
Project 10 | 2021-01-01 00:00:00
Project 10 | 2021-04-01 00:00:00
Project 11 | 2021-01-01 00:00:00
Project 12 | 2020-09-30 00:00:00
Project 12 | 2021-03-01 00:00:00
Project 12 | 2021-04-01 00:00:00
Project 12 | 2021-04-30 00:00:00
Spreadsheet: 754706d1636458578-want-to-add-additional-condition-in-formula-book11
Sheet: D2

L No | Name | Nationality | Passport | Blood Type | Accomodation | Contract | License Type | Cont No | Request Date | [NAME] | Iqama Receive Date | [NAME] | Tawakalna | 1st Dose | 2nd Dose | Dallah School | Transfer Dallah | Start Class | DL Expected Date | Finish class | License Receive Date | Status | Remarks
L_049285 | Idrissa . Tamboudja | NIGER | 09PC77036 | A+ | Aridh | INDIVIDUAL | Private |  | 2021-04-26 00:00:00 | 2415488283 | old driver | Done | Done | Done | Done | [NAME] | 2021-08-22 00:00:00 | 2021-09-16 00:00:00 |  | 2021-09-27 00:00:00 | 2021-09-29 00:00:00 |  | Done
L_127131 | Katchi Mohideen Mohamed Althaf | [NAME] | N8485336 | [NAME] | 0 | SLSC | Heavy |  | 2021-07-14 00:00:00 | 2499385025 | 2021-08-15 00:00:00 | Done | Done | Done | Done | Takhassusi |  |  |  |  | 2021-08-12 00:00:00 |  | Done
L_127127 | Muhammadu Razik Muhammadu Riyas | [NAME] | N6050765 | O+ | 0 | SLSC | Heavy |  | 2021-07-14 00:00:00 | 2499399869 | 2021-08-01 00:00:00 | Done | Done | Done | Done | Takhassusi |  |  |  |  | 2021-08-12 00:00:00 |  | Done
[NAME] | [NAME] | [NAME] | N4837355 | O+ | 0 | SLSC | Heavy |  | 2021-07-14 00:00:00 | 2499384945 | 2021-08-15 00:00:00 | Done | Done | Done | Done | [NAME] |  | 2021-08-04 00:00:00 |  | 2021-08-18 00:00:00 | 2021-08-23 00:00:00 |  | Done
L_127125 | Asanar Muhammadu Riyal | [NAME] | [NAME] | AB+ | Yasmin | SLSC | Heavy |  | 2021-07-14 00:00:00 | 2499399943 | 2021-08-01 00:00:00 | Done | Done | Done | Done | [NAME] |  | 2021-08-04 00:00:00 |  | 2021-08-18 00:00:00 | [NAME] |  | Done
L_127126 | Sabanayagam     - Thilesh | [NAME] | N8932670 | O- | 0 | SLSC | Heavy |  | 2021-07-14 00:00:00 | 2499401632 | 2021-08-01 00:00:00 | Done | Done | Done | Done | [NAME] |  | 2021-08-04 00:00:00 |  | 2021-08-18 00:00:00 | [NAME] |  | Done
Spreadsheet: 86235d1286263704-complicated-and-or-statment-help-required-book2
Sheet: Calcs

Additional Programme Properties
Decent Homes | [NAME] | All Windows | Windows (Inc DH) | Windows Only | Cyclical | Other | No. of Props
Spreadsheet: 20257317-d2f6-479b-b123-cc5bcbaf7b0d
Sheet: Attachment A

SOUTH ARKANSAS COMMUNITY COLLEGE
FY 2010-2011 BUDGET REQUEST JUSTIFICATION
DEPARTMENT
 | NAME                                                                                                                                    NUMBER |  | SUBMITTED BY
EXTRA HELP
5-13000 | Number Hours:                             Rate (per hour):  $
 | Justification:
 | Number Hours:                             Rate (per hour):  $
 | Justification:
 | TOTAL EXTRA HELP
STUDENT LABOR
5-13500 | Number Hours:                             Rate (per hour):  $7.25
 | Justification:
 | Number Hours:                             Rate (per hour):  $7.25
 | Justification:
 | TOTAL STUDENT LABOR
TRAVEL
5-25000  ADMINISTRATIVE TRAVEL
 | TOTAL ADMINISTRATIVE TRAVEL
5-25028  INSTRUCTIONAL/CLINICAL TRAVEL
 | TOTAL INSTRUCTIONAL/CLINICAL TRAVEL
5-25048  CONFERENCE/PROF DEV TRAVEL
 | TOTAL CONFERENCE/PROF DEV TRAVEL
5-25210 STUDENT TRAVEL
 | TOTAL STUDENT TRAVEL
SUPPLIES INCREASE
5-30000
OFFICIAL FUNCTIONS
5-36092
SMALL EQUIPMENT ($500.00 - $2,499.99)
5-78000
 | TOTAL SMALL EQUIPMENT
EQUIPMENT ($2,500.00 AND UP)
5-70000
 | TOTAL EQUIPMENT
Spreadsheet: 703877d1605203643-use-data-if-corresponding-times-are-between-certain-hours-co2
Sheet: Sheet1

Date | Time | Room | CO2 |  | Date | Time | Room | CO2
2020-11-02 00:00:00 | 07:03:00 | ELOY | 419 |  |  | 08:04:00 | ELOY | 498
2020-11-02 00:00:00 | 07:13:00 | ELOY | 418 |  | 2020-11-02 00:00:00 | 08:14:00 | ELOY | 473
2020-11-02 00:00:00 | 07:23:00 | ELOY | 406 |  | 2020-11-02 00:00:00 | 08:24:00 | ELOY | 449
2020-11-02 00:00:00 | 07:34:00 | ELOY | 424 |  | 2020-11-02 00:00:00 | 08:35:00 | ELOY | 537
2020-11-02 00:00:00 | 07:44:00 | ELOY | 587 |  | 2020-11-02 00:00:00 | 08:45:00 | ELOY | 670
2020-11-02 00:00:00 | 07:54:00 | ELOY | 545 |  | 2020-11-02 00:00:00 | 08:55:00 | ELOY | 813
2020-11-02 00:00:00 | 08:04:00 | ELOY | 498 |  | 2020-11-02 00:00:00 | 09:05:00 | ELOY | 906
2020-11-02 00:00:00 | 08:14:00 | ELOY | 473 |  | 2020-11-02 00:00:00 | 09:15:00 | ELOY | 1005
2020-11-02 00:00:00 | 08:24:00 | ELOY | 449 |  | 2020-11-02 00:00:00 | 09:23:00 | ELOY | 1067
2020-11-02 00:00:00 | 08:35:00 | ELOY | 537 |  | 2020-11-02 00:00:00 | 09:33:00 | ELOY | 1094
2020-11-02 00:00:00 | 08:45:00 | ELOY | 670 |  | 2020-11-02 00:00:00 | 09:43:00 | ELOY | 1153
2020-11-02 00:00:00 | 08:55:00 | ELOY | 813 |  | 2020-11-02 00:00:00 | 09:53:00 | ELOY | 1188
2020-11-02 00:00:00 | 09:05:00 | ELOY | 906 |  | 2020-11-02 00:00:00 | 10:02:00 | ELOY | 1153
2020-11-02 00:00:00 | 09:15:00 | ELOY | 1005 |  | 2020-11-02 00:00:00 | 10:13:00 | ELOY | 1150
2020-11-02 00:00:00 | 09:23:00 | ELOY | 1067 |  | 2020-11-02 00:00:00 | 10:22:00 | ELOY | 1151
2020-11-02 00:00:00 | 09:33:00 | ELOY | 1094 |  | 2020-11-02 00:00:00 | 10:31:00 | ELOY | 1165
2020-11-02 00:00:00 | 09:43:00 | ELOY | 1153 |  | 2020-11-02 00:00:00 | 10:39:00 | ELOY | 1047
2020-11-02 00:00:00 | 09:53:00 | ELOY | 1188 |  | 2020-11-02 00:00:00 | 10:49:00 | ELOY | 918
2020-11-02 00:00:00 | 10:02:00 | ELOY | 1153 |  | 2020-11-02 00:00:00 | 10:59:00 | ELOY | 833
2020-11-02 00:00:00 | 10:13:00 | ELOY | 1150
2020-11-02 00:00:00 | 10:22:00 | ELOY | 1151
2020-11-02 00:00:00 | 10:31:00 | ELOY | 1165
2020-11-02 00:00:00 | 10:39:00 | ELOY | 1047
2020-11-02 00:00:00 | 10:49:00 | ELOY | 918
2020-11-02 00:00:00 | 10:59:00 | ELOY | 833
2020-11-02 00:00:00 | 11:09:00 | ELOY | 729
2020-11-02 00:00:00 | 11:20:00 | ELOY | 649
2020-11-02 00:00:00 | 11:30:00 | ELOY | 628
2020-11-02 00:00:00 | 11:40:00 | ELOY | 617
2020-11-02 00:00:00 | 11:50:00 | ELOY | 789
2020-11-02 00:00:00 | 12:00:00 | ELOY | 944
2020-11-02 00:00:00 | 12:10:00 | ELOY | 875
2020-11-02 00:00:00 | 12:20:00 | ELOY | 789
Spreadsheet: 481786d1474643593-how-to-write-a-macros-to-compare-to-columns-and-match-amounts-but-this-is-a-bit-more-tricky-ap-ar-balancing-test
Sheet: Sheet2

-551.16 |  | -8417.8 | -7495.08 | -922.72 | 0
-826 |  | -2000 | -2000 | 0 | 0
-4268.72 |  | -18869.23 | -909.23 | -803 | -17157
-1238.98 |  | -1883 | -1883 | 0 | 0
-2308 |  | -1959.98 | -1959.98 | 0 | 0
-3477 |  | -6128 | -3063 | -3065 | 0
-579 |  | -551.16 | -551.16 | 0 | 0
-1351 |  | -2636.09 | -2636.09 | 0 | 0
-1883 |  | -3134 | -826 | -2308 | 0
-1367 |  | -11535.89 | -10148.45 | -1387.44 | 0
-3063 |  | -10712.17 | -10712.17 | 0 | 0
-1669 |  | -2000 | -2000 | 0 | 0
-1408 |  | -500 | -500 | 0 | 0
-17157 |  | -3477 | -3477 | 0 | 0
-144 |  | -49505.38 | -5625.39 | -39825.71 | -4054.28
-826 |  | -606.01 | -606.01 | 0 | 0
-803 |  | -144 | -144 | 0 | 0
-52242 |  | -1500 | -1500 | 0 | 0
3896 |  | -53911 | -52242 | -1669 | 0
-3896 |  | -9459.66 | -9459.66 | 0 | 0
826 |  | -2585.49 | -2585.49 | 0 | 0
-317.2 |  | -27375.83 | -27375.83 | 0 | 0
-387.5 |  | -5822.19 | -5822.19 | 0 | 0
-909.23 |  | -1408 | -1408 | 0 | 0
-1387.44 |  | -5245.36 | -2584.84 | -2660.52 | 0
-1672.63 |  | -2000 | -2000 | 0 | 0
-4054.28 |  | -11311.17 | -3122.96 | -2774.01 | -5414.2
-350.03 |  | -2000 | -2000 | 0 | 0
-941.71 |  | -350.03 | -350.03 | 0 | 0
-606.01 |  | -2000 | -2000 | 0 | 0
-500 |  | -1672.63 | -1672.63 | 0 | 0
11555.36 |  | -579 | -579 | 0 | 0
-11555.36 |  | -1238.98 | -1238.98 | 0 | 0
-203.44 |  | -840.42 | -200 | -640.42 | 0
-1959.98 |  | -9816.59 | -7100 | -1250.22 | -1466.37
-10712.17 |  | -2720.64 | -2720.64 | 0 | 0
-120451.83 |  | -387.5 | -387.5 | 0 | 0
-5625.39 |  | -21082.18 | -21082.18 | 0 | 0
-2636.09 |  | -72585.54 | -24541.83 | -24519.96 | -23523.75
-5822.19 |  | -71956.8 | -24264.9 | -24213.42 | -23478.48
-4082.93 |  | -1315.86 | -1315.86 | 0 | 0
-1331.27 |  | -6348.72 | -2080 | -4268.72 | 0
-2774.01 |  | -17675 | -7325 | -10350 | 0
-3122.96 |  | -6235.86 | -1691.78 | -3680 | -864.08
-2720.64 |  | -120451.83 | -120451.83 | 0 | 0
-2080 |  | -941.71 | -941.71 | 0 | 0
-21082.18 |  | -203.44 | -203.44 | 0 | 0
-39825.71 |  | -2731 | -2731 | 0 | 0
-9459.66 |  | -1668.2 | -1351 | -317.2 | 0
-2660.52 |  | -1367 | -1367 | 0 | 0
-10350 |  | -651.41 | -651.41 | 0 | 0
-7100 |  | -500 | -500 | 0 | 0
-7495.08 |  | -1000 | -1000 | 0 | 0
-640.42
-10148.45
-922.72
-27377.87
-1691.78
-2600
-1125
-1600
-2000
-23478.48
-24264.9
-23523.75
-864.08
-24519.96
-24541.83
-3680
-1250.22
-1466.37
-24213.42
-2000
-2585.69
-2000
-200
-1500
-2000
-2000
-500
-2000
-2584.84
Spreadsheet: darron_c_giron__8041__BLANKBOOKREQUEST
Sheet: Sheet1

From: | Risk Analysis and Reporting
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  |  | Risk Management
Subject: | New Book Request (to set up book in RisktRAC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason for Book | Administrator* | MTM | Prud | Realized
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List:
 | BOOK WILL NOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | For questions, call:
 | [NAME] (x57197)
 | [NAME] (x31462)
 | [NAME] ([NAME])
 | [NAME] (x33102)
Spreadsheet: 196987d1354179598-min-max-axis-options-issue-880000
Sheet: 2001

Artist | [NAME] | [NAME] | Weeks Charted
Lifehouse | Hanging By a Moment | 03:36:00 | 47 |  | Min
Train | Drops of Jupiter | 04:20:00 | 42 |  | [NAME]
Staind | It's Been Awhile | 04:25:00 | 38 |  | Major
Toya | I Do!! | 03:31:00 | 31
[NAME] | Fallin' | 03:30:00 | 29
[NAME] (feat. [NAME]) | I'm Real | 04:22:00 | 26
Enya | Only Time | 03:39:00 | 25
[NAME] | The Star Spangled Banner | 02:15:00 | 25
[NAME] | Can't Fight the Moonlight | 03:36:00 | 24
[NAME] | Family Affair | 04:26:00 | 23
Spreadsheet: 377932d1424207592-macro-to-to-merge-data-from-list-of-rows-excel-help
Sheet: output

list
Project A - Yes - B1 | 2015-12-01 00:00:00
Project A - No - B2 | 2015-12-01 00:00:00
Project A - Yes - B3 | 2015-12-01 00:00:00
Project A - Yes - B4 | 2015-12-01 00:00:00
Project A - Yes - B5 | 2015-12-01 00:00:00
Project A - Yes - B6 | 2015-12-01 00:00:00
Project A - Yes - B7 | 2015-12-01 00:00:00
Project A - Yes - B8 | 2015-12-01 00:00:00
Project A - Yes - B9 | 2015-12-01 00:00:00
Project A - Yes - B10 | 2015-12-01 00:00:00
Project A - Yes - B11 | 2015-12-01 00:00:00
Project A - Yes - B12 | 2015-12-01 00:00:00
Project A - Yes - B13 | 2015-12-01 00:00:00
Project B - Yes - B1 | 2015-12-07 00:00:00
Project B - No - B2 | 2015-12-07 00:00:00
Project B - Yes - B3 | 2015-12-07 00:00:00
Project B - Yes - B4 | 2015-12-07 00:00:00
Project B - Yes - B5 | 2015-12-07 00:00:00
Project B - Yes - B6 | 2015-12-07 00:00:00
Project B - Yes - B7 | 2015-12-07 00:00:00
Project B - Yes - B8 | 2015-12-07 00:00:00
Project B - Yes - B9 | 2015-12-07 00:00:00
Project B - Yes - B10 | 2015-12-07 00:00:00
Project B - Yes - B11 | 2015-12-07 00:00:00
Project B - Yes - B12 | 2015-12-07 00:00:00
Spreadsheet: 844309d1696029383-display-unique-values-with-a-count-for-a-date-range-unique-values-test-02
Sheet: Sheet1

NAME | DATE | AMOUNT
JOE | 2023-08-01 00:00:00 | 10
JOE | 2023-09-02 00:00:00 | 15
SUE | 2023-09-04 00:00:00 | 30
MARK | 2023-09-06 00:00:00 | 5
LISA | 2023-09-15 00:00:00 | 20
SUE | 2023-09-16 00:00:00 | 60
JOE | 2023-09-18 00:00:00 | 80
JOE | 2023-09-20 00:00:00 | 15
Spreadsheet: 59961d1260472196-using-pivottable-to-compute-of-total-by-row-field-book1-2-
Sheet: Sheet1

Customer Name | W/N | Total | Product Group
a | 1 | 2200 | ON
b | 2 | 120000 | ON
b | 3 | 28665 | ON
c | 4 | 19600 | AS
c | 4 | 24000 | AS
d | 5 | 16750 | TE
e | 6 | 42400 | MB
e | 6 | 5204 | BE
f | 7 | 15000 | PS
f | 7 | 81500 | PS
f | 7 | 227140 | RR
f | 8 | 160085 | PS
f | 8 | 5605 | RR
f | 8 | 5605 | PR
f | 9 | 11800 | RR
Spreadsheet: phillip_allen__29519__Socal Demand Forecast
Sheet: dem,rec,sto

 |  |  | 24 | 29 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
Expected Demand | Winter Forecast | 2000-01-06 00:00:00 | Bal Jan | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
Case 1 Demand | Total Receipts |  | 2700000 | 2725000 | 2800000 | 2850000 | 2850000 | 3000000 | 3000000 | 3000000 | 3000000 | 2800000 | 2750000 | 2650000
[NAME] | Inj/WD
Expected Demand | System Sendout |  | 3250000 | 3150000 | 2950000 | 2750000 | 2325000 | 2575000 | 2725000 | 2925000 | 2725000 | 2750000 | 2750000 | 3050000
 | Ending Inventory | 72302000
 |  |  | 24 | 29 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
Highest Demand | Winter Forecast | 2000-01-06 00:00:00 | Bal Jan | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
Case 5 Demand | Total Receipts |  | 2700000 | 2800000 | 2900000 | 3000000 | 3000000 | 3000000 | 3100000 | 3150000 | 3050000 | 3000000 | 3000000 | 2650000
[NAME] | Inj/WD
Highest Demand | System Sendout |  | 3450000 | 3250000 | 3050000 | 2820000 | 2470000 | 2670000 | 2870000 | 3070000 | 2870000 | 2820000 | 2770000 | 3170000
 | Ending Inventory | 72302000
 |  |  | 24 | 29 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
Lowest Demand | Winter Forecast | 2000-01-06 00:00:00 | Bal Jan | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
Adj. 1999 Demand | Total Receipts |  | 2700000 | 2600000 | 2600000 | 2700000 | 2700000 | 2700000 | 2750000 | 2750000 | 2800000 | 2800000 | 2800000 | 2650000
[NAME] | Inj/WD
Lowest Demand | System Sendout |  | 3150000 | 2933071.428571429 | 2835258.064516129 | 2583833.333333333 | 2214161.290322581 | 2421600 | 2643096.774193549 | 2706516.129032258 | 2645233.333333333 | 2400000 | 2738600 | 3114903.225806451
 | Ending Inventory | 72302000
Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  | average
Expected
High
Low
1999 |  |  | 2987387.096774193 | 2933071.428571429 | 2835258.064516129 | 2733833.333333333 | 2214161.290322581 | 2421600 | 2643096.774193549 | 2706516.129032258 | 2645233.333333333 | 2964096.774193549 | 2738600 | 3114903.225806451
1998 |  |  | 2979709.677419355 | 3107285.714285714 | 2722354.838709678 | 2586866.666666667 | 2275000 | 2400000 | 2675000 | 2905967.741935484 | 2551133.333333333 | 2319483.870967742 | 2501400 | 3137766.666666667
Spreadsheet: 834051d1687419843-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-revised-single-code-ans
Sheet: AA

 | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | FORMULA | Calculation method used for reference | Remarks
 | AG | 2022-01-01 00:00:00 |  |  |  | 19 |  |  | (20*G2)*E2/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-03-28 00:00:00 |  |  |  | 40 |  |  | (20*G3)*E3/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 6 |  |  | (20*G4)*E4/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 60 |  |  | (20*G5)*E5/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-09-01 00:00:00 | 2022-11-02 00:00:00 | 62 |  | 75 |  |  | ((20*G6*28)+(5*G6*34))/30 | 20 and 5 is the rate for AG category for the from and to date time frame respectively, 28 days are at the rate 20 and 34 days are for rate 5. 30 is the days for one month
 | AG | 2022-12-01 00:00:00 |  |  |  | 100 |  |  | ((10*E7*7.5)+(5*E7*(G7-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
 | AG | 2022-12-01 00:00:00 |  |  |  | 22 |  |  | ((7.5*10*E8)+(5*E8*(G8-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
 | AG | 2023-02-01 00:00:00 |  |  |  | 35 |  |  | ((7.5*10*E9)+(5*E9*(G9-7.5)))/30 | Here same logic applied as per above but here we have to keep one thing in mind, when you see in sheet BB you will see that in this from date to date time frame period there is in to date cells – symbol available, means these rates are presently active and its end date not yet came.
 |  |  |  |  |  |  |  |  | Days difference we have to count by subtracting dates, for example from [NAME] to 02/11/2022 the days will be 63 but we have to count this days as per subtraction method i.e. 62 days.