tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gstorey__12027__boces2
Sheet: Sheet1

 |  |  | US Chippewa | CNG [NAME]
 |  |  | 16359.6 | 82380.15 | 37500
 |  |  | 32718.6 | 197037.45 | 37530
 |  |  | 70890.6 | 365790.3 | 37561
 |  |  | 70890.6 | 448683.15 | 37591
 |  |  | 87250.2 | 554177.7 | 37622
 |  |  | 76344 | 494120.4 | 37653
 |  |  | 70890.6 | 388905.9 | 37681
 |  |  | 43624.2 | 223354.65 | 37712
 |  |  | 32718.6 | 131019.3 | 37742
 |  |  | 10906.2 | 35479.8 | 37773
 |  |  | 8179.8 | 32753.4 | 37803
 |  |  | 8019.6 | 32593.2 | 37834
 |  |  | 17041.25 | 85578.35 | 37865
 |  |  | 34081.875 | 204700.625 | 37895
 |  |  | 73844.375 | 380094.325 | 37926
 |  |  | 73844.375 | 466128.625 | 37956
 |  |  | 90885.625 | 575784.475 | 37987
 |  |  | 79525 | 513381 | 38018
 |  |  | 73844.375 | 404173.075 | 38047
 |  |  | 45441.875 | 232114.375 | 38078
 |  |  | 34081.875 | 136166.025 | 38108
 |  |  | 11360.625 | 36880.025 | 38139
 |  |  | 8520.625 | 34040.025 | 38169
 |  |  | 8353.75 | 33873.15 | 38200
 |  |  | 17722.9 | 88134.45 | 38231
 |  |  | 35445.15 | 210437.65 | 38261
 |  |  | 76798.15 | 390546 | 38292
 |  |  | 76798.15 | 479079.65 | 38322
 |  |  | 94521.05 | 591291.6 | 38353
 |  |  | 82706 | 527184 | 38384
 |  |  | 76798.15 | 414624.75 | 38412
 |  |  | 47259.55 | 238305.8 | 38443
 |  |  | 35445.15 | 140028.6 | 38473
 |  |  | 11815.05 | 37959.25 | 38504
 |  |  | 8861.45 | 35005.65 | 38534
Spreadsheet: 718377d1613128277-sum-vlookup-to-summarise-data-forum-sum-lookup
Sheet: PROPERTY 2

 | EXPENSE CATEGORY | DATE | AMOUNT | NOTES
 | MANAGEMENT SUPPLIES |  | 10
 | RATES |  | 500
 | KEYS |  | 20
 | WATER |  | 120
 | REPAIRS |  | 20
 | MAINTENANCE |  | 50
 | CLEANING |  | 55
 | ADVERTISING |  | 15
 | MANAGEMENT FEES |  | 10
 | CLEANING |  | 21
 | KEYS |  | 22
 | WATER |  | 55
 | REPAIRS |  | 14
 | MAINTENANCE |  | 15
 | CLEANING |  | 16
 | CLEANING |  | 55
 | MANAGEMENT FEES |  | 200
Spreadsheet: 765857d1643642712-sumif-changing-date-and-time-criteria-help-sample-1
Sheet: Sheet1

date | time |  |  | subtotal | Sale
2022-01-02 00:00:00 | 08:36:58 |  |  | 340
2022-01-02 00:00:00 | 08:50:30 |  |  | 1660
2022-01-02 00:00:00 | 08:55:56 |  |  | 300
2022-01-02 00:00:00 | 08:59:39 |  |  | 2130
2022-01-02 00:00:00 | 09:04:03 |  |  | 690
2022-01-02 00:00:00 | 09:11:13 |  |  | 820
2022-01-02 00:00:00 | 09:12:17 |  |  | 460
2022-01-02 00:00:00 | 09:18:07 |  |  | 1580
2022-01-02 00:00:00 | 09:20:53 |  |  | 620
2022-01-02 00:00:00 | 09:31:45 |  |  | 900
2022-01-02 00:00:00 | 09:44:53 |  |  | 1240
2022-01-02 00:00:00 | 09:46:45 |  |  | 400
2022-01-02 00:00:00 | 09:52:22 |  |  | 260
Spreadsheet: 2e57cd7c-b502-4985-b63b-a5ffeac0644f
Sheet: Sheet1

[NAME] | Units are no longer allowed to bring their own firewood to camp. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 2014-09-17 00:00:00
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716) 891-4073 OR E-MAIL [EMAIL]
SCHOELLKOPF |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | Code | FEE | [NAME] 6 - 8 | [NAME] 13 - 15 | [NAME] 20 - 22 | [NAME] 27 - 29
District/Council Events |  |  |  |  |  |  | IOLST
**Phillip (Lower) | 8 | S,W,E | 48
**Schoellkopf (Upper) | 12 | S,W,E | 72
Schwartz | 14 | S,W | 70
Score | 18 | S,W,E | 108 |  |  |  | IOLST
**Self | 12 | S,W,E | 72
Sikes | 16 | S,W,E,C | 96
**Toulmin | 18 | S,W,E | 108
Lean-To's
**Art Wood (Flats) | 12 | W | 48
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48
**Faso (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
Troop 7 Shelter | 20 | S,W,E | 96 |  |  | T1776
**Szymkowiak lean-to | 12 | W, E | 72
Tenting   $2 per person,per night |  |  |  |  |  |  | IOLST                      Open Skies
Tenting   $2 per person,per night
Tenting   $2 per person,per night
Day Hike $2 per person
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | [NAME] 6 - 8 | [NAME] 13 - 15 | [NAME] 20 - 22 | [NAME] 27 - 29
District/Council Events |  |  |  |  |  | MAPLE SUGAR DAY | CAMP CLOSED
[NAME] | 20 | S,W,E | 120 |  |  | P336 W | XXXX
Loegler 1 | 20 | C,S,W,E | 120 |  | T431 1/4W |  | XXXX
Loegler 2 | 20 | C,S,W,E | 120 |  |  |  | XXXX
[NAME] | 30 | C,S,W,E | 180 |  |  | T4 | XXXX
Lean-To's |  |  |  |  |  |  | XXXX
#1 Eagle | 12 | W | 48 |  |  |  | XXXX
#2 Whitetail | 12 | W | 48 |  |  |  | XXXX
#3 Dziedzic | 12 | W | 48 |  |  |  | XXXX
Moose | 10 | W | 40 |  |  |  | XXXX
Boss | 12 | W | 48 |  |  |  | XXXX
Tenting   $2 per person,per night |  |  |  |  |  |  | XXXX
Tenting   $2 per person,per night |  |  |  |  |  |  | XXXX
Day Hike $2 per person |  |  |  |  |  |  | XXXX
[NAME] |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | [NAME] 6 - 8 | [NAME] 13 - 15 | [NAME] 20 - 22 | [NAME] 27 - 29
District/Council Events
Cabin #1 | 24 | S,W,E | 144
Cabin #2 | 24 | S,W,E | 144
Leader's Lodge | 28 | S,W,E | 168
[NAME] | 30 | C,S,W,E | 180 |  |  | T58 W
Lean-To's
Stone Lean-To | 6 | [NAME] | 24
Troop 107 lean-to | 8 | W | 30
Ganosote Lean-To | 12 | W | 48
[NAME] | 12 | W | 48
[NAME] To | 12 | W | 48
Tenting   $2 per person,per night
Tenting   $2 per person,per night
Day Hike $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face.
Spreadsheet: 793380d1661437609-formula-to-sum-filtered-data-based-on-criteria-but-excluding-any-errors-i-e-n-a-formula-to-sum-filtered-data-but-exclude-errors
Sheet: Imported Data

Ref | Amount | Inv | Date | Type
XXMRKANL83 | 56518.13 | 741379 | 2022-08-16 00:00:00 | SW
XXMRKANL83 | 56518.13 | 741378 | 2022-08-16 00:00:00 | SW
XXMRKANL83 | 56518.13 | 741350 | 2022-08-17 00:00:00 | SW
XXMRKANL83 | 56518.13 | 741366 | 2022-08-17 00:00:00 | SW
XXMRKANL83 | 56518.13 | 741374 | 2022-08-17 00:00:00 | SW
XXMRKANY88 | 56518.13 | 741314 | 2022-08-17 00:00:00 | #N/A
XXMRKANY88 | 56518.13 | 741392 | 2022-08-17 00:00:00 | SW
XXMJ2PNY76 | 155788.61 | 741390 | 2022-08-17 00:00:00 | SW
XXMRKANY88 | 56339.93 | 741391 | 2022-08-17 00:00:00 | SW
XXMRKANY88 | 56518.13 | 741399 | 2022-08-17 00:00:00 | SW
XXMRKANY88 | 56518.13 | 741376 | 2022-08-17 00:00:00 | SW
XXMRKANL83 | 62763.02 | 741395 | 2022-08-17 00:00:00 | SW
XXMJ2PNS85 | 143853.7 | 741396 | 2022-08-17 00:00:00 | SW
XXMJ2PNT02 | 94225.34 | 741397 | 2022-08-16 00:00:00 | Cred
XXMJ2PNY78 | 143853.7 | 741398 | 2022-08-16 00:00:00 | Cred
XXMRKAME80 | 56518.13 | 741382 | 2022-08-17 00:00:00 | Cred
XXMRKANL83 | 56339.93 | 741400 | 2022-08-17 00:00:00 | Cred
XXMJ2PNY81 | 155554.53 | 741393 | 2022-08-16 00:00:00 | Cred
XXMJWJNY78 | 137848.41 | 741394 | 2022-08-17 00:00:00 | #N/A
Spreadsheet: 288097d1389096082-how-do-i-make-a-daily-list-of-orders-into-one-weekly-list-with-no-rows-empty-cash-sheets-tmp-jan-2014
Sheet: SUMMARY

 | CASH SHEET W/E |  | 2013-03-02 00:00:00 |  | TOTAL T/O |  |  |  | AVERAGE DISP |  |  |  | FRAME TOTAL
 | ALL PROFESSIONAL FEES |  |  |  | TOTAL SALES DISP ONLY
 |  |  | [NAME]
 | TOTAL TESTS |  | [NAME] | Number | Index | Number | Coatings | Number |  |  | Old Patients | New patients |  | Frame Type | Number
 |  |  | SV |  | 1.74 |  | Glacier Plus |  |  |  |  |  |  | L Metal
 |  |  | [NAME] |  | 1.67 |  | Glacier |  |  |  |  |  |  | L Plastic
 | Average Order Value |  | AutoGraph III |  | 1.6 |  | Ulti MAR |  |  |  |  |  |  | M Metal
 |  |  | Auto FF |  | PolyC |  | Ulti MAR PLUS |  |  |  |  |  |  | M Plastic
 |  |  | AutoPlus |  | Trivex |  | HMC |  |  |  |  |  |  | Rimless
 |  |  | Signature Plus |  | 1.5 |  | HMC Budget |  |  |  |  |  |  | Childrens
 |  |  | Ultimate HD Life |  | TOTAL |  | HC |  |  |  | TOTAL FRAMES SOLD |  |  | Reglaze
 |  |  | Other |  |  |  | Trans GP |  |  |  |  |  |  | TOTAL
 | CONVERSION RATE |  | CL |  |  |  | Trans G
 |  |  | DISPENSING TOTAL |  |  |  | Trans Only/React |  |  |  |  |  |  | TOTAL FRAMES SOLD
 |  |  |  |  |  |  | Uncoated
 |  |  |  |  |  |  | TOTAL
 | LENS TYPE |  |  |  | COATINGS |  |  |  |  | MATERIALS |  |  |  | FRAMES
Spreadsheet: 120644d1315422858-graphing-overlapping-trends-churn_trend_example
Sheet: Total Churn

 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Revenue Added | 13889 | 16120 | 26315 | 19889 | 32161 | 21534 | 28934 | 29323
Revenue Termed | -68946 | -23093 | -37954 | -30442 | -53488 | -44508 | -38296 | -32928
Subs Added | 228 | 442 | 587 | 447 | 460 | 385 | 956 | 739
[NAME] | -1215 | -355 | -625 | -1037 | -672 | -747 | -560 | -430
Spreadsheet: 90179d1289936686-sum-total-question-yesterdays-totals
Sheet: 1108

11/08/2010  Performance Data
 |  | 1st Work |  |  |  |  | QC |  |  |  | SC | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT | MMIG, RSCH & UPDT | All Other DA | IA  Forms Pkgs | IA  Trans | EDIT w/pass | PASS | FAIL | IA QC | SURINQ  &  Death Cert
 |  |  |  |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 13 | 10 |  |  |  |  |  |  |  | 121 | 0.5 | board | 7 | 17.28571428571428
 | Dustin |  | 27 | 8 |  |  |  |  |  |  |  | 213 | 0.5 | trending | 8 | 26.625
 | Sharron | 10 | 5 | 2 |  |  |  |  |  | 23 |  | 120 |  |  | 10 | 12
 | Roxy |  | 16 | 7 |  |  |  |  |  |  |  | 133 |  |  | 8.5 | 15.64705882352941
 | [NAME] |  |  |  |  |  | 4 | 13 | 1 |  |  | 108 |  |  | 8 | 13.5
 | Ana |  | 12 | 29 |  |  |  |  |  |  |  | 171 |  |  | 8 | 21.375
 | Maria |  | 2 | 17 |  |  |  |  |  |  |  | 65 |  |  | 6.5 | 10
 | [NAME] | 1 | 8 | 11 | 13 | 6 |  |  |  |  |  | 165 | 1.75 | CISS/QC | 8.25 | 20
 | Petra | * | * | * | * | * | * | * | * | * | * | #N/A | * | Out of Office | 0 | #N/A
 | Regina |  |  |  |  |  | 4 | 9 | 3 |  |  | 96 |  |  | 8.5 | 11.29411764705882
 | Noy |  |  |  |  |  | 5 | 10 | 1 |  |  | 96 |  |  | 8 | 12
 | [NAME] | * | * | * | * | * |  | * | * | * | * | #N/A | * | Out of Office / Paternity | 0 | #N/A
 | [NAME] |  |  |  |  |  |  |  |  |  | 47 | 75.2 | 2 | reporting | 5.5 | 13.67272727272727
 | Michelle |  |  |  |  |  |  |  |  |  | 23 | 36.8 |  |  | 2 | 18.4
 | Keisha |  |  |  |  | 6 |  |  |  |  |  | 36 |  |  | 4.5 | 8
 | [NAME] |  |  |  |  | 23 |  |  |  |  |  | 138 | 0.67 | Emails / Updates | 7.67 | 17.99217731421121
TEAM TOTALS | Pts Earned: | 1 | 7 | 3 | 3 | 6 | 6 | 6 | 6 | 3 | 1.6 |  |  |  |  | #N/A
 | TASK VOLUME: | 11 | 83 | 84 | 13 | 35 | 13 | 32 | 5 | 23 | 70 | 1574 | 5.42 |  | 100.42 | 15.67416849233221
 | Pts Earned: | 11 | 581 | 252 | 39 | 210 | 78 | 192 | 30 | 69 | 112
Spreadsheet: 38768d1236900632-counting-duplicate-cells-in-multiple-columns-pt2-test
Sheet: Sheet5

1 | 2 | 3 |  | 1&2&3 | 1&2 | 1&3 | 2&3
[NAME] | Fred | [NAME] |  | 0 | 1 | 0 | 1
Fred | [NAME] | [NAME] |  | 1 | 1 | 1 | 0
[NAME] | [NAME] | Fred |  | 0 | 0 | 0 | 0
[NAME] | [NAME] | [NAME] |  | 0 | 0 | 0 | 1
[NAME] | [NAME] | [NAME] |  | 0 | 0 | 0 | 0
1 & 2 & 3 | 1 |  |  | 1 | 2 | 1 | 2
1 & 2 | 2
2 & 3 | 2
1 & 3 | 1
Spreadsheet: 63986d1264826310-vlookup-and-sum-sumproduct-monday-thru-friday-sheets-mldover89-sdg11
Sheet: Thursday

Public Que
8am - 12pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Hicks | Rachel | 4
Bellar | Marcus | 4
Holder | [NAME] | 4
[NAME] | [NAME] | 4
[NAME] | Justin | 4
Self | Cameron | 4
[NAME] | Adam | 4
Daily Total |  |  | 0 |  |  | 00:04:10 |  |  | 00:01:02
Totals
12 - 5pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
[NAME] | [NAME] | 4 |  |  |  |  |  |  | 00:00:00
Kinney | Damon | 4 |  |  |  |  |  |  | 00:00:00
Donnelly | [NAME] | 4 |  |  |  |  |  |  | 00:00:00
Hirschi | Evin | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | Jessica | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] | 4 |  |  |  |  |  |  | 00:00:00
Offutt | Tawney | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] | 4
Daily Totals |  |  | 0 |  |  | 00:06:20 |  |  | 00:02:07
Totals
Inbound Que
8am - 12pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Hicks | Rachel | 4 |  |  |  |  |  |  | 00:00:00
Bellar | Marcus | 4 |  |  |  |  |  |  | 00:00:00
Holder | [NAME] | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | Justin | 4 |  |  |  |  |  |  | 00:00:00
Self | Cameron | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | Adam | 4 |  |  |  |  |  |  | 01:00:00
Daily Totals |  |  | 0 |  |  | 00:00:00 |  |  | 00:00:00
Totals
12pm - 5pm
Agent |  | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
[NAME] | [NAME] | 4 |  |  |  |  |  |  | 00:00:00
Kinney | Damon | 4 |  |  |  |  |  |  | 00:00:00
Donnelly | [NAME] | 4 |  |  |  |  |  |  | 00:00:00
Hirschi | Evin | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | Jessica | 4 |  |  |  |  |  |  | 00:00:00
[NAME] | [NAME] | 4 |  |  |  |  |  |  | 01:00:00
Offutt | Tawney | 4 |  |  |  |  |  |  | 02:00:00
[NAME] | [NAME] | 4
Daily Totals |  |  | 0 |  |  | 00:00:00 |  |  | 00:00:00
Totals
Spreadsheet: kate_symes__18257__DJ Index 4-2
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-02 00:00:00
Flow Date: | 2001-04-02 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 277.2 | 2000
 | Firm Trades Purchases | 293.3333333333333 | 1200
[NAME] | Firm Trades Sales | 220 | 600
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 283.5294117647059 | 6800
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 228.3333333333333 | 600
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 235.2549575070822 | 5648
 | Firm Trades Purchases | 233.0645161290323 | 2480
[NAME] | Firm Trades Sales | 134.6713615023474 | 1504
 | Firm Trades Purchases | 130 | 200
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 210 | 160
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 147.8571428571429 | 280
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 231.9285714285714 | 5600
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 144.25 | 1600
 | Firm Trades Purchases | 130 | 200
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 225.1713395638629 | 5136
 | Firm Trades Purchases | 222.6 | 2000
[NAME] | Firm Trades Sales | 132.125 | 1600
 | Firm Trades Purchases | 129 | 1000
Spreadsheet: 109048d1305947433-pivot-table-ptreportlayout
Sheet: Sheet1

 | Sample Data
 | Department | Location | Cost |  |  | Department | Location | Sum of Cost
 | Accounting | East | 500 |  |  | Accounting | East | 1500
 | Accounting | East | 500 |  |  | Accounting | West | 1000
 | Accounting | East | 500 |  |  | Accounting Total |  | 2500
 | Finance | West | 500 |  |  | Finance | West | 1000
 | Finance | West | 500 |  |  | Finance Total |  | 1000
 | Sales | East | 500 |  |  | Sales | East | 1000
 | Sales | West | 500 |  |  | Sales | West | 1500
 | Accounting | West | 500 |  |  | Sales Total |  | 2500
 | Accounting | West | 500 |  |  | Grand Total |  | 6000
 | Sales | East | 500
 | Sales | West | 500
 | Sales | West | 500
 |  |  |  |  | Desired Result
 |  |  |  |  | Accounting | East | 1500
 |  |  |  |  | Accounting | West | 1000
 |  |  |  |  | Finance | West | 1000
 |  |  |  |  | Sales | East | 1000
 |  |  |  |  | Sales | West | 1500
 |  |  |  |  | Total |  | 6000
Spreadsheet: 720404d1614142400-find-a-price-from-mulitple-sheets-based-on-item-type-width-and-height-sample
Sheet: XH

 | 24 | 28 | 32 | 36 | 40 | 44
24 | 400 | 404 | 408 | 412 | 416 | 420
28 | 405 | 409 | 413 | 417 | 421 | 425
32 | 410 | 414 | 418 | 422 | 426 | 430
36 | 415 | 419 | 423 | 427 | 431 | 435
40 | 420 | 424 | 428 | 432 | 436 | 440
44 | 425 | 429 | 433 | 437 | 441 | 445
Spreadsheet: 386324d1427735524-make-sum-calculate-blank-cells-as-0-schedule-sample-test-01
Sheet: Projection

 |  |  | [NAME]
 |  |  |  |  | Hrs | Total |  | Hrs | Total |  | Hrs | Total |  | Hrs | Total |  | Hrs | Total |  | Hrs | Total |  | Hrs | Total | Total Hrs | Total Pay
Hire Date |  | Rate |  | Sat |  |  | Sun |  |  | Mon |  |  | Tue |  |  | Wed |  |  | Thu |  |  | Fri
2015-01-01 00:00:00 | 1 | 20 | Employee 1
2015-01-01 00:00:00 | 2 | 19 | Employee 2
2015-01-01 00:00:00 | 3 | 18 | Employee 3
2015-01-01 00:00:00 | 4 | 17 | Employee 4
2015-01-01 00:00:00 | 5 | 16 | Employee 5
2015-01-01 00:00:00 | 6 | 15 | Employee 6
2015-01-01 00:00:00 | 7 | 14 | Employee 7
2015-01-01 00:00:00 | 8 | 13 | Employee 8
2015-01-01 00:00:00 | 9 | 12 | Employee 9
 |  |  | Subtotal Type A
 |  |  | Subtotal Type B
 |  |  | DAILY PROJECTION
Spreadsheet: 717842d1612879714-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Schedule

Day | Monday | Monday | Monday | Tuesday | Tuesday
System | System 1 | System 2 | System 3 | System 4 | System 5
Extract Names from Roster tab List which are not in listed above based on day for multiple columns
Monday | Tuesday | Wednesday
 |  |  |  | Everything to the left will be formulas which can auto update based on data entered above. It should also alow for columns to be added or deleted above without having to change the formulas to the left. For example if a new system is added in between column B and C there would then be 6 systems showing from colums B to G. The formulas to the left should also account for the new system automatically based on the day for that system.
Spreadsheet: 871890d1718286295-how-to-countif-dynamically-based-on-slicer-selection-report-14-juni-me5a-capex-c11-c12-c13-
Sheet: Summary

 | Date | 2024-03-01 00:00:00 | 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 | 2024-04-26 00:00:00 | 2024-05-03 00:00:00 | 2024-05-10 00:00:00 | 2024-05-17 00:00:00 | 2024-05-24 00:00:00 | 2024-05-31 00:00:00 | 2024-06-07 00:00:00 | 2024-06-14 00:00:00
 | Existing
 | New | 21 | 6 | 13 | 11 | 31 | 14 | 58 | 13 | 21 | 30 | 13 | 34 | 44 | 35
 | Total | 133 | 112 | 112 | 102 | 116 | 101 | 133 | 120 | 112 | 108 | 96 | 110 | 124 | 131
 | PR to PO | 19
 | Date |  | No of PR
 | 2024-03-01 00:00:00 |  | 133
 |  |  | -27
 |  |  | 6
 | 2024-03-08 00:00:00 |  | 112
 |  |  | -13
 |  |  | 13
 | 2024-03-15 00:00:00 |  | 112
 |  |  | -21
 |  |  | 11
 | 2024-03-22 00:00:00 |  | 102
 |  |  | -17
 |  |  | 31
 | 2024-03-29 00:00:00 |  | 116
 |  |  | -29
 |  |  | 14
 | 2024-04-05 00:00:00 |  | 101
 |  |  | -26
 |  |  | 58
 | 2024-04-26 00:00:00
 |  |  | -26
 |  |  | 13
 | 2024-05-03 00:00:00
 |  |  | -29
 |  |  | 21
 | 2024-05-10 00:00:00
 |  |  | -34
 |  |  | 30
 | 2024-05-17 00:00:00
 |  |  | -25
 |  |  | 13
 | 2024-05-24 00:00:00
 |  |  | -20
 |  |  | 34
 | 2024-05-31 00:00:00
 |  |  | -30
 |  |  | 44
 | 2024-06-07 00:00:00
 |  |  | -28
 |  |  | 35
 | 2024-06-14 00:00:00
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Admins

Admins | ok
[NAME] | Financial | [NAME]
[NAME] | Derivitives | [NAME]
[NAME] | Central/East | [NAME]
[NAME] | Central/East | [NAME]
Amanda Hubble | West | [NAME]
[NAME] | Structuring/Fundys | [NAME]
[NAME] | Texas | [NAME]
[NAME] | Chicago | [NAME]
[NAME] | Clerk/Runner | [NAME]
[NAME] | Weather | [NAME]
[NAME] | Logistics | [NAME]
[NAME] | Mexico | [NAME] | 12
Spreadsheet: 82596d1282660517-printing-a-selected-area-when-sheet-is-locked-book3sample
Sheet: Sue

 | Form 200157 |  |  |  |  |  |  |  |  |  |  | Time brought forward
 | FLEXIBLE WORKING HOURS -- Time Record |  |  |  |  |  | Name |  |  |  | Debit
 | Week Commencing |  |  |  |  |  |  | Week Commencing
 |  | Mon. | [NAME]. | Wed | Thurs. | Fri. |  |  | Mon. | [NAME]. | Wed | Thurs. | Fri. |  | Weeks 1 - 4
 | In |  |  |  |  |  |  | In
 | Out |  |  |  |  |  |  | Out
 | In |  |  |  |  |  |  | In
 | Out |  |  |  |  |  |  | Out
 | Lunch |  |  |  |  |  |  | Lunch
 | Time taken off |  |  |  |  |  |  | Time taken off
 | Total Hours |  |  |  |  |  |  | Total Hours
 | Standard hr. | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 |  |  | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333
 | Credit. / Debit. |  |  |  |  |  |  | Credit. / Debit.
 | Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00 |  | Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00
 | Balance from previous week |  |  |  |  | 1900-01-01 00:00:00 |  | Balance from previous week |  |  |  |  | 1900-01-01 00:00:00
 | Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00 |  | Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00
 | Total hours  for week |  |  |  |  | 1900-01-01 00:00:00 |  | Total hours for week |  |  |  |  | 1900-01-01 00:00:00
 | Week Commencing |  |  |  |  |  |  | Week Commencing
 |  | Mon. | [NAME]. | Wed | Thurs. | Fri. |  |  | Mon. | [NAME]. | Wed | Thurs. | Fri.
 | In |  |  |  |  |  |  | In
 | Out |  |  |  |  |  |  | Out
 | In |  |  |  |  |  |  | In
 | Out |  |  |  |  |  |  | Out
 | Lunch |  |  |  |  |  |  | Lunch
 | Time taken off |  |  |  |  |  |  | Time taken off
 | Total Hours |  |  |  |  |  |  | Total Hours
 | Standard hr. | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 |  |  | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333 | 0.3083333333333333
 | Credit. / Debit. |  |  |  |  |  |  | Credit. / Debit.
 | Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00 |  | Credit / Debit for this week |  |  |  |  | 1900-01-01 00:00:00
 | Balance from previous week |  |  |  |  | 1900-01-01 00:00:00 |  | Balance from previous week |  |  |  |  | 1900-01-01 00:00:00
 | Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00 |  | Total Credit / Debit |  |  |  |  | 1900-01-01 00:00:00
 | Total hours  for week |  |  |  |  | 1900-01-01 00:00:00 |  | Total hours for week |  |  |  |  | 1900-01-01 00:00:00 |  | Next
 | Certified times |  |  |  |  |  |  | Checked by
 | Correctly recorded |  | ……… | ……………………………. |  |  |  | Supervising Officer |  | ……. | ……………………………
Spreadsheet: benjamin_rogers__1198__Calpine version 3
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax |  | 400
Franchise Tax
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income