tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 81177d1281441122-complicated-data-calculation-problem-test
Sheet: Sheet1

original [NAME] table
 | 2-Dec-2009 | 3-Dec-2009 | 4-Dec-2009 | 5-Dec-2009 | 6-Dec-2009 | 7-Dec-2009 | 8-Dec-2009
a | 2 | 1 | 0 | 2 | 0 | 1 | 0
b | 0 | 2 | 1 | 0 | 0 | 2 | 0
c | 2 | 2 | 0 | 0 | 0 | 0 | 2
desired Pivot table
 | 2-Dec-2009 | 3-Dec-2009 | 4-Dec-2009 | 5-Dec-2009 | 6-Dec-2009 | 7-Dec-2009 | 8-Dec-2009
a | 2 | 3 | 3 | 5 | 5 | 6 | 6
b | 0 | 2 | 3 | 3 | 3 | 5 | 5
c | 2 | 4 | 4 | 4 | 5 | 5 | 7
Spreadsheet: 08688de9-7591-437f-b361-5cf25a09ce50
Sheet: Expenses

 | use purple line items for streamlined compliance reporting only
HOUSING OPERATING BUDGET - EXPENSES
 | Project Name:
 | Date: |  |  |  | Annual Inflation Rate Factor: | 0.03
Annual Operating Expenses |  |  | Annual per Unit | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Property Management:
 | On-site
 | On-site (resident mgr/other adm unit)
 | Contracted (Off-Site)
Professional Services - Legal/Audit/Accounting
Office & Administration
Advertising/Marketing & Promotion
[NAME]
Commercial Bad Debt
Security
Repairs:
 | Repairs & Maint performed under contract
 | Repairs & Maint performed by property mgmt staff
Unit Turnover:
 | Turnover performed under contract
 | Turnover performed by property mgmt staff
Elevator
Landscaping
Utilities:
 | Electric
 | Natural Gas
 | Water & Sewer
 | Garbage Removal
 | Other Utilities:
Real Estate Taxes
Insurance
Compliance Monitoring Fees
Asset Management Fees
Resident Services
Gross Replacement Reserve Deposits
Commercial Expense (See Comment): |  |  | 0
Other:
Total Annual Operating Expenses:
Less Debt Service:
Must Pay Debt (Complete for Annual Reporting): |  | Lender:
First Position Loan Principal
First Position Loan Interest
Subordinate Loan Principal
Subordinate Loan Interest
Other Hard Debt Principal
Other Hard Debt Interest
Total Must Pay Debt
Cash Flow Based Pmts (Priority Order): |  | Recipient:
Priority Payment 1
Priority Payment 2
Priority Payment 3
Priority Payment 4
Priority Payment 5
Priority Payment 6
Debt Service:
Permanent loan
Rate | Term (Years) | Loan Amount
OAHTC Permanent loan
Rate | Term (Years) | Loan Amount
Portion of perm loan w/o OAHTC (if applicable)
 | 1
Deferred Developer Fee
Rate | Term (Years) | Loan Amount
 | 1
Amortized Debt (HOME Loan, Partnership Loans, etc.) & Cashflow Loans
Rate | Term (Years) | Loan Amount
 | 1
 | 1
 | 1
WITHOUT OAHTC
Effective Gross Income:
Total Annual Operating Expenses:
Net Operating Income:
Primary Debt Service
Total Debt Service
Cash Flow Per Year
Primary Debt Coverage Ratio
Total Debt Coverage Ratio
WITH OAHTC
Effective Gross Income:
Total Annual Operating Expenses:
Net Operating Income:
Primary Debt Service
Total Debt Service:
Cash Flow Per Year:
Primary Debt Coverage Ratio:
Total Debt Coverage Ratio:
Spreadsheet: 03d1eac0-ffea-406d-a92b-337775862625
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
 | 6345.0 Labour Price Index, Australia
 | Total Hourly Rates of Pay Excluding Bonuses: Private Sector by State, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248258L | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248335F | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248412X | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248489W | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248566R | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248643J | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248720A | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248797X | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  All industries ;  Private ;  All occupations ; |  |  | Original | A2248190C | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2009
Spreadsheet: 878591d1725697155-any-alternative-function-or-combination-to-replicate-filter-function-in-excel-2016-bala_adangal_ol
Sheet: MAIN

SN | SD | AREA | TAX | PNO | PNAME |  | PATTA NOS
1 | 1 | 0.285 | 1.12 | 7 | பாலாஜி
3 | 3 | 0.07.50 | 0.31 | 367 | பரசுராமன்
3 | 4A | 0.14.00 | 0.51 | 7 | பாலாஜி
3 | 4B | 0.08.50 | 0.32 | 2422 | உமாதேவி
3 | 4C | 0.20.50 | 0.79 | 7 | பாலாஜி
4 | 1A | 0.01.00 | 0.06 | 2426 | தினகரன்
4 | 1B | 0.02.00 | 0.08 | 619 | வெங்கடாசலம்
4 | 1C | 0.82.00 | 0.08 | 7 | பாலாஜி
4 | 1D | 0.98.50 | 0.09 | 7 | பாலாஜி
4 | 1E | 0.06.00 | 0.22 | 2477 | குப்பன் + 1
Spreadsheet: 80820d1281004732-how-to-use-max-function-with-multiple-condition-maximum
Sheet: Sheet 1

Contact | Action | Date | What is the Maximum  Date for each Contact
90009843 | DINP | 2010-06-03 00:00:00 | P | 1 | P
90009843 | WARN | 2010-05-21 00:00:00 |  | 0
90009843 | INST | 2010-04-23 00:00:00 |  | 0
97510845 | CONP | 2010-05-23 00:00:00 | P | 1 | P
97510845 | WARN | 2010-05-23 00:00:00 |  | 0
97510845 | INST | 2010-04-23 00:00:00 |  | 0
97496760 | DINP | 2010-06-01 00:00:00 | P | 1 | P
97496760 | WARN | 2010-05-23 00:00:00 |  | 0
97496760 | INST | 2010-04-23 00:00:00 |  | 0
90000839 | WARN | 2010-06-22 00:00:00 |  | 0
90000839 | CONP | 2010-06-22 00:00:00 | P | 1 | P
90000839 | INST | 2010-04-23 00:00:00 |  | 0
97628598 | CONP | 2010-06-23 00:00:00 | P | 1 | P
97628598 | WARN | 2010-06-23 00:00:00 |  | 0
97628598 | WARN | 2010-05-23 00:00:00 |  | 0
97628598 | CONP | 2010-05-27 00:00:00 |  | 0
97628598 | INST | 2010-04-23 00:00:00 |  | 0
90006288 | CONP | 2010-05-29 00:00:00 | P | 1 | P
90006288 | WARN | 2010-05-28 00:00:00 |  | 0
90006288 | INST | 2010-04-23 00:00:00 |  | 0
90088372 | DINP | 2010-06-03 00:00:00 | P | 1 | P
90088372 | WARN | 2010-05-21 00:00:00 |  | 0
90088372 | INST | 2010-04-23 00:00:00 |  | 0
90008856 | DINP | 2010-07-04 00:00:00 | P | 1 | P
90008856 | WARN | 2010-06-21 00:00:00 |  | 0
90008856 | INST | 2010-04-23 00:00:00 |  | 0
90088755 | CONP | 2010-06-21 00:00:00 | P | 1 | P
90088755 | WARN | 2010-06-21 00:00:00 |  | 0
90088755 | INST | 2010-04-23 00:00:00 |  | 0
90055585 | CONP | 2010-07-06 00:00:00 | P | 1 | P
90055585 | DINP | 2010-07-05 00:00:00 |  | 0
90055585 | WARN | 2010-06-22 00:00:00 |  | 0
90055585 | CONP | 2010-05-23 00:00:00 |  | 0
90055585 | WARN | 2010-05-22 00:00:00 |  | 0
90055585 | INST | 2010-04-23 00:00:00 |  | 0
90087879 | WARN | 2010-06-21 00:00:00 |  | 0
90087879 | CONP | 2010-06-22 00:00:00 | P | 1 | P
90087879 | INST | 2010-04-23 00:00:00 |  | 0
90077477 | DINP | 2010-07-04 00:00:00 | P | 1 | P
90077477 | WARN | 2010-06-21 00:00:00 |  | 0
90077477 | INST | 2010-04-23 00:00:00 |  | 0
Spreadsheet: 865551d1712624053-formula-to-spill-days-and-dates-date-sample-aligw
Sheet: Sheet1

Enter Start Date | 2024-04-02 00:00:00
Week #1
Day | Date
2024-04-03 00:00:00 | 2024-04-03 00:00:00
2024-04-04 00:00:00 | 2024-04-04 00:00:00
2024-04-05 00:00:00 | 2024-04-05 00:00:00
2024-04-06 00:00:00 | 2024-04-06 00:00:00
2024-04-07 00:00:00 | 2024-04-07 00:00:00
2024-04-08 00:00:00 | 2024-04-08 00:00:00
Week#2
Day | Date
2024-04-10 00:00:00 | 2024-04-10 00:00:00
2024-04-11 00:00:00 | 2024-04-11 00:00:00
2024-04-12 00:00:00 | 2024-04-12 00:00:00
2024-04-13 00:00:00 | 2024-04-13 00:00:00
2024-04-14 00:00:00 | 2024-04-14 00:00:00
2024-04-15 00:00:00 | 2024-04-15 00:00:00
Spreadsheet: 78972d1279216969-excel-2007-min-ave-max-values-but-exclude-blanks-steel-20price-20comparison-4-
Sheet: Steel

STEEL
[NAME] | Density | Length         m | Width           m | Weight       kg | Supplier A |  | Supplier B |  | Supplier C |  | Supplier D |  | Supplier E |  | Supplier F |  |  | LOWEST | Supplier | 2nd | 3rd | HIGHEST | AVE
 |  |  |  |  | R / Sheet | R /  kg | R / Sheet | R /  kg | R / Sheet | R /  kg | R / Sheet | R /  kg | R / Sheet | R /  kg | R / Sheet | R /  kg
1.6 | 8045 | 2.45 | 1.225 | 38.63209000000001 | 319.33 | 8.265926073375786 | 336.26 | 8.704162782805692 | 331 | 8.568006545853459 |  | 0 | 320 | 8.283269168196698 | 310 | 8.02441700669055 |  | 8.02441700669055 |  | 8.265926073375786 | 8.283269168196698 | 8.704162782805692 | 8.369156315384435
2 | 8045 | 2.45 | 1.225 | 48.29011250000001 | 401 | 8.30397734111719 | 412.63 | 8.544813392182508 | 355 | 7.351401386774569 |  | 0 | 300 | 6.212451876147523 |  | 0 |  | 6.212451876147523 |  | 7.351401386774569 | 8.30397734111719 | 8.544813392182508 | 7.603160999055447
3 | 8045 | 2.45 | 1.225 | 72.43516875000002 | 500 | 6.902724306830581 | 611.31 | 8.439408792017204 | 585 | 8.076187438991779 | 580 | 8.007160195923474 | 510 | 7.040778792967192 | 505 | 6.971751549898887 |  | 6.902724306830581 |  | 6.971751549898887 | 7.040778792967192 | 8.439408792017204 | 7.573001846104852
4 | 7845 | 2.45 | 1.225 | 94.179225 | 773.46 | 8.212639252446598 |  | 0 | 740 | 7.857359199972181 | 750 | 7.963539729701535 | 760 | 8.069720259430888 | 765 | 8.122810524295565 |  | 7.857359199972181 |  | 7.963539729701535 | 8.069720259430888 | 8.212639252446598 | 8.045213793169355
5 | 7845 | 2.45 | 1.225 | 117.72403125 | 864.85 | 7.34641849091453 | 950 | 8.06972025943089 |  | 0 | 880 | 7.475109292946508 | 850 | 7.220276021596058 | 860 | 7.305220445379542 |  | 7.220276021596058 |  | 7.305220445379542 | 7.34641849091453 | 8.06972025943089 | 7.483348902053505
Spreadsheet: 709185d1608201465-change-countif-combined-with-index-to-a-sumproduct-file-1
Sheet: Sheet1

Parameter 1
Q
W
E
R
T
T
R
E
R
R
Q
W
E
R
Q
W
E
W
Q
W
Spreadsheet: keith_holst__19419__NewDealCheck
Sheet: Run Query

Daily Hedge Strip
User ID: | kholst_pc
Password: | kholst_pc
Included Deals | ALL
Today
Days in Month
Day of Month | 9 | Update this cell daily.
PromptMonth | 2000-04-01 00:00:00
StartRange | D4
Enter NYMEX Date:
[NAME] | NXB2 | NX1
2000-02-23 00:00:00 | 2000-02-24 00:00:00 | 2000-02-25 00:00:00
Please Note:  Once the 'RUN ' button has been pressed, please do not disturb Excel.  Doing so will make you a bad person.
User ID:
Password: | Current Post Id's | Prior Post Id's
Date |  |  | # | Name | Type
Post Ids | 1358394 | 763380 | 1 | PRICE
 | 1358395 | 763679 | 2 | BASIS | Basis
 | 1358398 | 763712 | 3 | Gas Daily | [NAME] | POSITION Post ID
 | 1358401 |  | 4 | Gas Daily Index | [NAME]
 | 1358396 | 763695 | 5 | Physical Index
Spreadsheet: 198515d1354806048-problem-sort-sort-example
Sheet: Sheet1

START # | 53
 |  |  | LIST |  | Sort From a given value then continue from 0 |  | NORMAL SORT |  | NEW SORT
 |  |  | 51 |  | 53 |  | 1
 |  |  | 59 |  | 53 |  | 3
 |  |  | 74 |  | 56 |  | 5
 |  |  | 59 |  | 59 |  | 11
 |  |  | 52 |  | 59 |  | 16
 |  |  | 53 |  | 69 |  | 33 |  |  | start at 53 for example
 |  |  | 86 |  | 72 |  | 34
 |  |  | 56 |  | 74 |  | 35
 |  |  | 51 |  | 77 |  | 44
 |  |  | 3 |  | 85 |  | 46
 |  |  | 96 |  | 86 |  | 51
 |  |  | 35 |  | 91 |  | 51
 |  |  | 44 |  | 96 |  | 52
 |  |  | 33 |  | 1 |  | 53
 |  |  | 85 |  | 3 |  | 53
 |  |  | 77 |  | 5 |  | 56
 |  |  | 11 |  | 11 |  | 59
 |  |  | 72 |  | 16 |  | 59
 |  |  | 53 |  | 33 |  | 69
 |  |  | 69 |  | 34 |  | 72
 |  |  | 1 |  | 35 |  | 74
 |  |  | 34 |  | 44 |  | 77
 |  |  | 5 |  | 46 |  | 85
 |  |  | 16 |  | 51 |  | 86
 |  |  | 46 |  | 51 |  | 91
 |  |  | 91 |  | 52 |  | 96
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0121

01/21/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 11 | 7 | 6 |  |  |  |  | 91 | 2.5 | capmgmt/reporting | 5.5 | 16.54545454545455
 | Dustin | 7 | 8 | 10 |  |  |  |  | 118 | 2.5 | capmgmt/trending | 5 | 23.6
 | Sharron |  | 12 | 1 |  |  |  |  | 44 |  |  | 2 | 22
 | Roxy | 1 | 5 | 8 |  |  |  |  | 81 |  |  | 4.25 | 19.05882352941176
 | [NAME] |  |  |  |  |  | 10 | 1 | 88 |  |  | 8 | 11
 | Ana | 8 | 20 | 12 |  |  |  |  | 172 |  |  | 8.25 | 20.84848484848485
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 15 | 41 | 3 |  |  |  |  | 177 | 1 | ciss | 8.25 | 21.45454545454545
 | Petra | 6 | 1 | 7 |  | 6 | 4 | 5 | 155 | 6 | [NAME] | 12.75 | 12.15686274509804
 | Regina |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Noy | 3 |  |  |  | 1 | 6 | 1 | 64 |  |  | 4 | 16
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] | 12 | 8 |  |  |  |  |  | 48 |  | SME | 3 | 16
 | Michelle | 26 |  |  |  |  |  |  | 52 |  | SME | 2.25 | 23.11111111111111
 | Keisha |  | 7 | 11 |  |  |  |  | 109 |  |  | 6.5 | 16.76923076923077
 | [NAME] | 6 | 20 | 1 |  |  |  |  | 80 | 4 | training | 4.75 | 16.84210526315789
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 220.5445130033365
 | TASK VOLUME: | 95 | 129 | 59 | 0 | 7 | 20 | 7 | 1279 | 16 |  | 74.52 | 17.16317767042405
 | Pts Earned: | 190 | 387 | 472 | 0 | 14 | 160 | 56
 |  |  |  |  |  |  |  | Average PTS | 79.93875 |  | Total Task Volume |  | 317
 | MID-DAY PPH  19.36
Spreadsheet: 842320d1694435530-using-if-ifs-with-match-function-sample
Sheet: Sheet1

RESULT (WANT ONLY TO PICK RECORDS ONLY WHERE is YEAR in Sheet 2 is 18, 19, 20 or 21) | Name | [NAME] | Vertical | Season | Year | Region
1
Spreadsheet: 267031d1379916070-insert-table_array-as-a-variable-into-vlookup-based-on-data-validation-result-theklaw_match
Sheet: Sheet1

 | Apples |  |  |  |  | Oranges |  |  |  |  | Pears
 |  | Boxes |  |  |  |  | Boxes |  |  |  |  | Boxes
 | # Per Box | 5 | 10 | 15 |  | # Per Box | 5 | 10 | 15 |  | # Per Box | 5 | 10 | 15
 | 10 |  |  |  |  | 10 |  |  |  |  | 10
 | 20 |  |  |  |  | 20 |  |  |  |  | 20
 | 30 |  |  |  |  | 30 |  |  |  |  | 30
 | 40 |  |  |  |  | 40 |  |  |  |  | 40
 | 50 |  |  |  |  | 50 |  |  |  |  | 50
 | Table | # of Boxes | # Per Box | Price
 | Apples | 10 | 20
 | Oranges | 15 | 10
 | Pears | 5 | 40
 | Total
Spreadsheet: 749357d1632754569-how-to-get-the-difference-between-2nd-and-3rd-difbetween2ndand3rd
Sheet: Sheet1

 | 65 | 112 | 162 | 221 | 286
 | 57 | 82 | 146 | 202 | 299
 | 32 | 79 | 117 | 180 | 226
 | 26 | 65 | 121 | 162 | 216
Expected result:
Spreadsheet: 488537d1478706039-dynamic-range-in-chart-error-dynamic-range-error-in-chart
Sheet: Sheets1

Sales | 0 | 0.03333333333333333 | 0.06666666666666667 | 0.1 | 0.1166666666666667 | 0.1333333333333333 | 0.15 | 0.1666666666666667 | 0.1833333333333333 | 0.2 | 0.2333333333333333 | 0.2666666666666667 | 0.3 | 0.3333333333333334 | 0.3666666666666667 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 | 0.6499999999999999 | 0.7 | 0.7333333333333333 | 0.7666666666666666 | 0.8 | 0.8333333333333334 | 0.8666666666666667 | 0.9 | 0.85 | 0.8 | 0.75 | 0.7 | 0.65 | 0.6 | 0.5666666666666667 | 0.5333333333333333 | 0.5 | 0.4666666666666667 | 0.4333333333333333 | 0.4 | 0.3833333333333334 | 0.3666666666666667 | 0.35 | 0.3333333333333333 | 0.3166666666666667 | 0.3 | 0.3166666666666667 | 0.3333333333333333 | 0.35 | 0.3666666666666667 | 0.3833333333333334 | 0.4 | 0.4666666666666667 | 0.5333333333333333 | 0.6000000000000001 | 0.6666666666666667 | 0.7333333333333334 | 0.8 | 0.8333333333333334 | 0.8666666666666667 | 0.9 | 0.9333333333333333 | 0.9666666666666667 | 1 | 0.95 | 0.9 | 0.85 | 0.7999999999999999 | 0.75 | 0.7 | 0.6333333333333333 | 0.5666666666666667 | 0.5 | 0.4333333333333333 | 0.3666666666666666 | 0.3 | 0.2833333333333333 | 0.2666666666666667 | 0.25 | 0.2333333333333333 | 0.2166666666666667 | 0.2 | 0.1333333333333333 | 0.06666666666666667
X Axis | 08:00:00 | 08:10:00 | 08:20:00 | 08:30:00 | 08:40:00 | 08:50:00 | 09:00:00 | 09:10:00 | 09:20:00 | 09:30:00 | 09:40:00 | 09:50:00 | 10:00:00 | 10:10:00 | 10:20:00 | 10:30:00 | 10:40:00 | 10:50:00 | 11:00:00 | 11:10:00 | 11:20:00 | 11:30:00 | 11:40:00 | 11:50:00 | 12:00:00 | 12:10:00 | 12:20:00 | 12:30:00 | 12:40:00 | 12:50:00 | 13:00:00 | 13:10:00 | 13:20:00 | 13:30:00 | 13:40:00 | 13:50:00 | 14:00:00 | 14:10:00 | 14:20:00 | 14:30:00 | 14:40:00 | 14:50:00 | 15:00:00 | 15:10:00 | 15:20:00 | 15:30:00 | 15:40:00 | 15:50:00 | 16:00:00 | 16:10:00 | 16:20:00 | 16:30:00 | 16:40:00 | 16:50:00 | 17:00:00 | 17:10:00 | 17:20:00 | 17:30:00 | 17:40:00 | 17:50:00 | 18:00:00 | 18:10:00 | 18:20:00 | 18:30:00 | 18:40:00 | 18:50:00 | 19:00:00 | 19:10:00 | 19:20:00 | 19:30:00 | 19:40:00 | 19:50:00 | 20:00:00 | 20:10:00 | 20:20:00 | 20:30:00 | 20:40:00 | 20:50:00 | 21:00:00 | 21:10:00 | 21:20:00 | 21:30:00 | 21:40:00 | 21:50:00 | 22:00:00
Sum using OFFSET: |  |  |  |  |  | If I try to replace the series values of sales with any of the ranges (formula or defined name, offset or indirect) it gives me an error. Any ideas why?
Sum using INDIRECT:
Sum using defined names:
Spreadsheet: 798505d1664523424-to-summarize-data-by-label-name-copy-of-examples
Sheet: Expected sheet data

Forecast by Branch by SKU
Branch | Product | SKU | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
A | AB | ABB
A | AB | ABC
A | AB | ABD
A | AB | ABE
A | AB | ABF
A | AB | ABG
A | AC | ABB
A | AC | ABC
A | AC | ABD
A | AC | ABE
A | AC | ABF
A | AC | ABG
B | AB | ABB
B | AB | ABC
B | AB | ABD
B | AB | ABE
B | AB | ABF
B | AB | ABG
B | AC | ABB
B | AC | ABC
B | AC | ABD
B | AC | ABE
B | AC | ABF
B | AC | ABG
C | AB | ABB
C | AB | ABC
C | AB | ABD
C | AB | ABE
C | AB | ABF
C | AB | ABG
C | AC | ABB
C | AC | ABC
C | AC | ABD
C | AC | ABE
C | AC | ABF
C | AC | ABG
D | AB | ABB
D | AB | ABC
D | AB | ABD
D | AB | ABE
D | AB | ABF
D | AB | ABG
D | AC | ABB
D | AC | ABC
D | AC | ABD
D | AC | ABE
D | AC | ABF
D | AC | ABG
E | AB | ABB
E | AB | ABC
E | AB | ABD
E | AB | ABE
E | AB | ABF
E | AB | ABG
E | AC | ABB
E | AC | ABC
E | AC | ABD
E | AC | ABE
E | AC | ABF
E | AC | ABG
Spreadsheet: 77962d1278433227-creating-unique-lists-advanced-filters-or-not
Sheet: Sheet2

THIS PAGE NEEDS TO BE POPULATED WITH THE TUTOR NAMES
Tutor Name | Tutor Number | Tutor Name (No Duplicates)
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Georgina Gold |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | Fred Flinstone
Fred Flinstone |  | Georgina Gold
[NAME]
[NAME]
[NAME]
[NAME]
Georgina Gold
Fred Flinstone
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Georgina Gold
Fred Flinstone
[NAME]
[NAME]
Fred Flinstone
Spreadsheet: 818630d1676974884-assistance-in-updating-formula-for-date-functions-eg-datevalue-day-etc-for-leap-years-leap-year-formula-ans
Sheet: Home and Utilities

 |  | Last day of february
Spreadsheet: daren_farmer__5038__HPLN0410
Sheet: Sheet1

HPLN0410.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - April 10, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-04-10 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 0 | 8
Enron (S) |  | LS HPL Katy I/C |  | Enron | 0 | 20
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 165922d1341397965-if-a-a-sheet-1-equals-a-in-sheet-2-then-count-b-b-sheet-1-for-all-cells-containing-1-count-if-sample-1-
Sheet: Sheet1

Profit Centre | Total
BRISTOL IT PERMANENT | 7
BRISTOL IT PERMANENT | 6
BRISTOL IT PERMANENT | 5
BRISTOL IT PERMANENT | 5
BRISTOL IT PERMANENT | 2
BRISTOL IT PERMANENT | 2
BRISTOL IT PERMANENT | 2
BRISTOL IT PERMANENT | 1
BRISTOL IT PERMANENT | 1
LONDON IT PERMANENT | 6
LONDON IT PERMANENT | 5
LONDON IT PERMANENT | 4
LONDON IT PERMANENT | 3
LONDON IT PERMANENT | 2
LONDON IT PERMANENT | 1
LONDON IT PERMANENT | 1
Spreadsheet: 887936d1738250521-rotating-schedule-advice-line-assignment
Sheet: April 3- May 28 2023

Line # | PRI | LINE ASSIGNEMENT
1 | 74470434 | [NAME]
2
3 | 14055201 | TERRY TEAL
4 | 69212074 | KRYSTEN PIRAINO
5 | 37902628 | [NAME]
6 | 96710802 | [NAME]
7 | 24564591 | GREG COLE
8 | 24252204 | [NAME]
9 | 37015923 | [NAME]
10 | 54010810 | EVA ZAJAC
11 | 39606759 | ROBYN HORNYAK
12 | 62359622 | [NAME]
13 | 31919219 | [NAME]
14 | 81680244 | EDWIN BORRAYO
15 | 14440237 | RYAN FORAN
16 |  | [NAME] HARRIS- A/SUPT
17 | 48910368 | [NAME]
18 |  | [NAME]
19 | 38296314 | REAL PICARD
20 | 99717662 | [NAME]
21 | 57182604 | NATHAN WALKER
22 | 80764576 | SACHA PROVENCHER
23 | 56735057 | KRIS FLEGG
24 | 17642418 | [NAME]
25 | 50473190 | [NAME] GILL- traffic
26 | 60559721 | TRAVIS [NAME]
27 | 24668206 | Jesse O'Niell- HCVM
28 | 23877944 | MAGDA ARMAND
29 |  | MEGAN LEROEYE | Sara AMOS (CEU) ([NAME])
30 |  | EMILIO MOLLO (CEU)
31 | 46545786 | TRAVIS WILLICK
32 | 91188121 | [NAME]
33 | 30337526 | KEVIN HALL
34 | 19680880 | [NAME]
35 | 11404574 | [NAME]
36 |  | [NAME] MURRAY- [NAME]
37 | 39537714 | [NAME]
38 | 38704552 | [NAME]
39 | 96994835 | [NAME]
40 | 80229522 | JUSTIN HALL
41 | 54174449 | [NAME] GORDON
42 | 97102016 | [NAME]
43
44 | 17694647 | CAT STEVENS
45 |  | [NAME] TATTERSALL
46 | 54059453 | SCOTT NICHOLLS
47 | 13820311 | [NAME] DILAPO
48 |  | CHRIS PATTERSON- [NAME]
49 | 22025448 | [NAME]
50 | 88663760 | HELEN STEWART
51 | 97873233 | LARRY CARROLL
52 | 94685045 | TERRI BELTRAME
53 | 70483566 | YARO TURCHMANOVYC
54 | 55107613 | [NAME]
55
56 | 61474940 | GERRY GAGNON
57
58 | 26290499 | JASON WALLINGTON
59
60
61 | 93909454 | ROB CARD
62 | 72583983 | LARRY TUFTS
63 | 27328198 | DAVE JOHNSTON
64 | 86407643 | [NAME]
65
66 | 92699685 | [NAME]
67
68 | 9702816 | [NAME]
69 | 28504631 | [NAME]
70
71 | 70600287 | [NAME]
72 |  | [NAME]
73 | 12731471 | DOUG HORNYAK
74 |  | [NAME]
75 | 49413503 | KERRI SUSICK
76 | 31395554 | DAN COBER
11 | 80123988 | RYAN WILLICK
22 | 44353499 | [NAME] DODD
47 | 60855495 | [NAME]
37 | 95806474 | [NAME]