tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216409d1361763522-sum-the-cells-value-of-every-row-that-belong-to-a-specific-criterion-example
Sheet: Sheet1

Product name | Day of transaction | How much
A | 2012-08-12 00:00:00 | 2340
A | 2012-08-25 00:00:00 | 2210 |  |  |  |  | Product name | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00
A | 2012-09-06 00:00:00 | 2123 |  |  |  |  | A
A | 2012-09-17 00:00:00 | 1357 |  |  |  |  | B
A | 2012-09-23 00:00:00 | 1650 |  |  |  |  | C
A | 2012-09-30 00:00:00 | 1283
A | 2012-10-07 00:00:00 | 1544
B | 2012-10-15 00:00:00 | 741
A | 2012-10-20 00:00:00 | 1710
B | 2012-10-28 00:00:00 | 1834
C | 2012-11-07 00:00:00 | 2055
A | 2012-11-18 00:00:00 | 856
B | 2012-11-22 00:00:00 | 1587
B | 2012-11-30 00:00:00 | 1882
A | 2012-12-24 00:00:00 | 2390
B | 2012-12-26 00:00:00 | 1775
C | 2012-12-27 00:00:00 | 2500
A | 2013-01-03 00:00:00 | 3131
B | 2013-01-05 00:00:00 | 5100
A | 2013-01-26 00:00:00 | 745
C | 2013-02-05 00:00:00 | 2861
A | 2013-02-06 00:00:00 | 1222
B | 2013-02-07 00:00:00 | 1639
C | 2013-02-11 00:00:00 | 745
C | 2013-02-21 00:00:00 | 1244
B | 2013-02-23 00:00:00 | 694
Spreadsheet: 692802d1598573632-sensitivity-analysis-sensitivity-analysis
Sheet: Two-Variable Data Table

Controllable Input |  |  |  |  | Net Cash Flow
 | Unit Price | 29
[NAME] |  |  |  |  |  | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900
 | Units Sold | 500 |  |  | 6 |  | 2650 | 3800 | 4950 | 6100 | 7250 | 8400 | 9550 | 10700
 | Unit Variable Cost | 6 |  |  |  | 1250 | 2375 | 3500 | 4625 | 5750 | 6875 | 8000 | 9125 | 10250
 | Fixed Costs | 10000 |  |  |  | 1000 | 2100 | 3200 | 4300 | 5400 | 6500 | 7600 | 8700 | 9800
Performance Measure |  |  |  |  |  | 750 | 1825 | 2900 | 3975 | 5050 | 6125 | 7200 | 8275 | 9350
 | Net Cash Flow |  |  |  |  | 500 | 1550 | 2600 | 3650 | 4700 | 5750 | 6800 | 7850 | 8900
 |  |  |  |  |  | 250 | 1275 | 2300 | 3325 | 4350 | 5375 | 6400 | 7425 | 8450
 |  |  |  |  |  | 0 | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000
 |  |  |  |  |  | -250 | 725 | 1700 | 2675 | 3650 | 4625 | 5600 | 6575 | 7550
 |  |  |  |  |  | -500 | 450 | 1400 | 2350 | 3300 | 4250 | 5200 | 6150 | 7100
 |  |  |  |  |  | -750 | 175 | 1100 | 2025 | 2950 | 3875 | 4800 | 5725 | 6650
 |  |  |  |  |  | -1000 | -100 | 800 | 1700 | 2600 | 3500 | 4400 | 5300 | 6200
Spreadsheet: 108750d1305735433-applying-different-formulas-if-values-are-negative-or-positive-or
Sheet: Sheet1

 | Coordinates
 | For ∆X>0, [NAME] |  |  |  |  |  |  | I've added 200*pi() to have the result in grads and not radians, also the circle has 400 grads up from 360 degrees
 | X | Y
1 | 2566.321 | 2003.255 |  | [NAME]
2 | 8899.654 | 3221.699 |  | Manual calculation
 | For ∆X<0, [NAME]
 | X | Y
1 | 12699.178 | 3000 |  | [NAME] |  | The correct result after this bad one should be 400-207.474
2 | 4220.322 | 4000 |  | Manual calculation
 | For ∆X<0, ∆Y<0
 | X | Y
1 | 14554.366 | 9877.633 |  | [NAME]
2 | 4121.332 | 2500.221 |  | Manual calculation
 | For ∆X>0, ∆Y<0
 | X | Y
1 | 4098.3 | 7787.906 |  | [NAME] |  | The correct result after this bad one should be 800-444.77
2 | 9887.701 | 2879.326 |  | Manual calculation
Spreadsheet: 876296d1722974168-attendance-tracking-with-occurrence-points-over-6-month-rolling-period-attendance-tracker
Sheet: June

 | 2024-06-01 00:00:00
 |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  | Weekends
 | V | S | U | N | T | L
Employee | Vacation | Sick | Unexcused | NC-NS | Tardy | Late Return | Total Points
Spreadsheet: 827898d1683112912-sort-function-or-any-ignoring-header-in-existing-let-function-dummy-aligw
Sheet: Sheet2

Header1 | Header2 | Header3 | Header4 | Header5 | Header6 | Header7 | Header8 | Header9 | Header10 | Header11
Jasmine |  |  | 2097.6.4 |  |  |  | 126364 | Text1 | 44 | 2
Jasmine |  |  | 2098.77 |  |  |  | ABC |  | 97
Jasmine |  |  | 2084.2.6 |  |  |  | 895634 |  |  | 98
Jasmine |  | 2067.8 |  |  |  |  |  | Tex9 | 88 | 32
Jasmine |  |  |  |  |  |  | 64638 |  |  | 47
Jasmine |  |  |  |  |  |  | 9631 |  | 56
Jasmine |  |  |  |  |  |  | 126364 |  | 97 | 97
Lily |  |  |  |  |  |  | ADFG |  |  | 66
Lily |  |  |  |  |  |  | 64638 |  | 34
Rose |  |  |  |  |  |  | 2696 |  |  | 88
Spreadsheet: 74308d1274856772-total-by-job-type-and-date-earnings
Sheet: Summary Yearly

Monthly earnings | Total | Totl Cash | Total Invoice | Totl Advertising | [NAME] | Totl Fashion | Totl Film | Total HC in | Total HC out | Ttl Internet | Ttl Print | Totl Theatre | Total TV | Total Video | Total Tax owed
1 July  08 - 30 June 09
1 July  09 - 30 June 10
1 July  10 - 30 June 11
1 July  11 - 30 June 12
1 July  12 - 30 June 13
1 July  13 - 30 June 14
1 July  14 - 30 June 15
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: MIKES

S.No | DESCRIPTION | MODEL | SERAIL NO | QTY | FINISH
1 | [NAME]  [NAME] | PU 901 | 17C008043 | 1 | Black
2 | Shure hand held mic | PG24E/SM58 |  | 2 | Black
3 | Shure Handheld Mic | PG24E/ PG58-M7 | 415081046 | 1 | Black
4 | Shure Goose Neck Mike | MX418C | No Number | 2 | Black
5 | Studio master  collar mike | ER 58/ EL-58 |  | 0 | Black
6 | Studio master  hand [NAME] | ER11/EM11 | 239-320-10037756 | 1 | Black
7 | Beyer Dynamics  Profession Microphone | SHM205AS |  | 5 | Black
8 | Shure hand held LAVALIER | PG58/185-M7 |  | 0 | Black
9 | Shure Handheld Mic | PG14E1PG185-K7 | 3HL1866802 | 1 | Black
10 | Beyer Dynamics Mikes | MPC22EQS3W |  | 0 | Black
11 | DBX RTA measurement microphone |  |  | 1
 | BACK
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74028

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 408 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20403 |  | Cactus Reports |  |  |  |  |  | Z0074028
 |  | Hyperion Entries |  |  |  | 01/01/96 | 12/31/97
 |  | General Ledgers |  |  |  | 01/01/98 | 01/01/98
 |  | Financial Statements |  |  |  | 01/01/97 | 12/31/97
 |  | Wires |  |  |  | 01/01/97 | 12/31/97
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: 137181d1326990665-advice-for-construction-estimating-spreadsheet-sign-pricing-demo
Sheet: Signs

SIGNAGE PRICNG DEMO
SIGN 1 | ADA INTO LANDSCAPE |  | TOTALs
[NAME] | ADA into landscape
QUANTITY | 3
*PANEL #1 | MO - ADA 12"x18" |  | 62
*PANEL #2 | 12"x24" FINE |  | 15
*PANEL #3 | NONE |  | 0
*POST TYPE | 2LB U-CHANNEL 10' |  | 10
*ADD 1 | U- chan fasteners |  | 2
*ADD 2 | Concrete footing |  | 10
*ADD 3 | NONE
*ADD 4 | NONE
CREW HOURS/EA | 0.5 |  | 0.5
*LABOR RATE | STANDARD |  | 1
 | MATERIAL COST/EA
 | TOTAL MATERIAL COST
 | LABOR/EA
 | TOTAL LABOR
Spreadsheet: 741318d1626966255-combine-different-cells-and-add-characters-before-amount-test
Sheet: Sheet1

 |  |  |  |  | %*0 # | %#000 %$00 %&00 _x0000_
Code |  | Product | Price |  |  | %)       Agente          %[Sky Country     %]VLEIS           %~_x0000_
5001 |  | BEEF SIDES A | 67.67750000000001
5002 |  | BEEF FOREQUARTERS A | 64.29362499999999
5003 |  | BEEF HINDQUARTER A | 71.06137500000001
5004 |  | BEEF RUMP & LOIN A | 89.26875
5005 |  | BEEF BUTTOCK A | 76.41405
5006 |  | BEEF PISTOLA A | 92.8395
Spreadsheet: 7194634c-0cf9-4322-97f5-b029f4098197
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0003271 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Hestron Park WWTF | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | [NAME] | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 67000
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 142277d1329762568-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Area 4

Date | reference | problem |  |  | problem a
2012-02-18 00:00:00 |  |  |  |  | problem b
2012-02-01 00:00:00 | xyz432 | problem a |  |  | problem c
2012-02-02 00:00:00 | xyz433 | [NAME] |  |  | [NAME]
2012-02-03 00:00:00 | [NAME] | [NAME]
2012-02-04 00:00:00 | xyz435 | [NAME]
2012-02-05 00:00:00 | xyz436 | problem c
2012-02-06 00:00:00 | xyz437 | problem b
2012-02-07 00:00:00 | xyz438 | problem b
2012-02-18 00:00:00 | xyz439 | problem c
2012-02-19 00:00:00 | [NAME] | problem a
 |  | problem c
 |  | problem c
 |  | problem c
 |  | problem c
 |  | problem c
 |  | problem c
 |  | problem c
 |  | problem c
 |  | problem c
 |  | problem c
Spreadsheet: 63665d1264548066-lookup-v-to-clearly-show-difference-mismatches
Sheet: Sheet1

Col A | Col B |  | A Not in B | B Not in A |  | A Not in B | B Not in A
10 | 50 |  | 10 | 50 |  | >0 | >0
35 | 42 |  |  | 42
35 | 20 |  |  | 20
34 | 13 |  | 34 | 13
16 | 46
26 | 24
44 | 16
34 | 50 |  | 34 | 50
23 | 48 |  | 23 | 48
18 | 19 |  |  | 19
31 | 35
31 | 29
46 | 12 |  |  | 12
29 | 47 |  |  | 47
44 | 42 |  |  | 42
44 | 26
30 | 31 |  | 30
24 | 13 |  |  | 13
11 | 44 |  | 11
36 | 19 |  | 36 | 19
10 | 26 |  | 10
16 | 48 |  |  | 48
44 | 50 |  |  | 50
36 | 38 |  | 36 | 38
29 | 38 |  |  | 38
44 | 18
 | 26
 | 24
 | 16
 | 45 |  |  | 45
 | 39 |  |  | 39
 | 17 |  |  | 17
 | 35
Spreadsheet: errol_mclaughlin_jr__9999__EES
Sheet: Run Query

 | ccheung_pc
 | ccheung_pc
Counterparty_cd | Counterparty_Legal_Nm | Cp_status | ID
ENRONENESER | Enron Energy Services | I | 53228
ENRONENESER10 | Enron Energy Services Europe B.V | I | 132198
ENRONENESER3 | Enron Energy Services Italy, S.r.l | N | 86138
ENRONENESER4 | Enron Energy Services Spain, S.L. | N | 86141
ENRONENESER5 | Enron Energy Services Engineering UK Limited | A | 86191
ENRONENESER6 | Enron Energy Services Portugal, LDA | A | 86294
ENRONENESER7 | Enron Energy Services Netherlands B.V. | A | 86296
ENRONENESER8 | Enron Energy Services North America, Inc. | A | 90053
ENRONENESER9 | Enron Energy Services International Leasing, Inc. | N | 90747
ENRONENESERCAN | Enron Energy Services Canada Corp. | N | 85186
ENRONENESERDUB | Enron Energy Services, Inc. - Dublin | A | 59032
ENRONENESERINC | Enron Energy Services, Inc. | A | 57956
ENRONENESERLLC | Enron Energy Services, LLC | N | 60305
ENRONENESEROPR | Enron Energy Services Operations, Inc. | A | 60306
ENRONENESERVSWE | Enron Energy Services Sweden AB | A | 101287
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Gas Logistics

 | Gas Logistics
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 2293233.6
 | Analyst & Associate | 0 |  |  |  |  | 308094.3936
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 553138.068
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 0
ENAOUTSV | Outside Services | 0 |  |  |  |  | 0 | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense |  |  |  |  |  | 97108.09920000001
ENAMKTEX | Marketing |  |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  | 295787.52 | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  | 63383.04 | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 32 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 0 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 48732d1248010363-updating-a-master-spreadsheet-from-other-spreadsheets-unit1
Sheet: Sheet1

 | P1 | P2 | P3 | P4 | P5 | P6 | M1 | M2 | M3 | D1 | D2 | D3 |  | Result
[NAME] | x | x | x | x | x | x | x |  | x |  | x | x |  | Pass
Pie Face | x | x | x | x |  | x | x | x | x | x | x | x |  | Fail
Rik | x | x | x | x | x | x | x |  | x | x | x | x |  | Pass
Spreadsheet: 761951d1641310965-find-future-on-hand-quantity-for-duplicate-values-sample-excel-forum
Sheet: Sample

Part | Total OH | Reqd | Required Date | Remaining OH
102 | 10 | 5 | 2021-02-15 00:00:00 |  | 5
101 | 12 | 12 | 2021-03-15 00:00:00 |  | 0
112 | 10 | 14 | 2021-05-15 00:00:00 |  | -4
118 | 5 | 8 | 2021-07-13 00:00:00 |  | -3
105 | 3 | 9 | 2021-07-15 00:00:00 |  | -6
108 | 3 | 6 | 2021-10-29 00:00:00 |  | -3
105 | 3 | 20 | 2021-11-15 00:00:00 |  | -26
114 | 4 | 7 | 2021-11-15 00:00:00 |  | -3
101 | 12 | 4 | 2021-11-18 00:00:00 |  | -4
117 | 10 | 16 | 2021-12-06 00:00:00 |  | -6
109 | 4 | 4 | 2021-12-07 00:00:00 |  | 0
106 | 0 | 3 | 2021-12-10 00:00:00 |  | -3
102 | 10 | 8 | 2021-12-14 00:00:00 |  | -3
103 | 5 | 10 | 2021-12-15 00:00:00 |  | -5
116 | 15 | 14 | 2021-12-15 00:00:00 |  | 1
102 | 10 | 5 | 2021-12-21 00:00:00 |  | -8
120 | 2 | 2 | 2021-12-21 00:00:00 |  | 0
113 | 6 | 25 | 2022-01-05 00:00:00 |  | -19
110 | 22 | 21 | 2022-01-07 00:00:00 |  | 1
104 | 6 | 30 | 2022-01-07 00:00:00 |  | -24
Spreadsheet: 53623d1253562565-multi-regression-how-to-rank-the-weight-contribution-of-each-variable-multi-regression-question
Sheet: Sheet1

STEP 1) Below are the SALES and variables that I used for multi-regression |  |  |  |  |  |  |  |  | STEP 2) By runing [NAME], I understood which variables were explaining SALES
 |  | E | F | G | H | I | J
 | SALES | Variable 1 | Variable 2 | Variable 3 | Variable 4 | Variable 5 | Variable 6
month 1 | 58 | 88 | 15 | 11.1 | 25.9 | 417.9534314185913 | 0 |  |  | Variable 6 | Variable 4 | Variable 2 | Constant
month 2 | 53 | 88 | 15 | 11.1 | 22 | 438.3347344477074 | 0
month 3 | 53 | 88 | 18 | 11 | 31.8 | 484.3342886840119 | 0 |  | LINEST | 0.006798301711154544 | 0.1482544131772105 | 0.5410917069866257 | 41.47749655769456
month 4 | 55 | 89 | 16 | 11.4 | 18.1 | 697.0680361512186 | 0 |  |  | 0.003092427086766351 | 0.08980474544753203 | 0.3438584225657222 | 6.499791415532258
month 5 | 55 | 89 | 16 | 11.4 | 36.8 | 926.252002804432 | 0 |  | R2 | 0.5349280723738633 | 3.089326843077042 | #N/A | #N/A
month 6 | 54 | 90 | 16 | 11.6 | 33.2 | 907.9337646977665 | 0 |  |  | 3.834016780331111 | 10 | #N/A | #N/A
month 7 | 54 | 90 | 16 | 11.6 | 30.9 | 926.9693535742136 | 0 |  |  | 109.7748822807221 | 95.43940343356363 | #N/A | #N/A
month 8 | 46 | 89 | 13 | 12 | 3.6 | 948.8491510785251 | 0
month 9 | 56 | 89 | 14 | 11.8 | 34.5 | 992.7158011441004 | 311.48
month 10 | 61 | 90 | 19 | 12 | 26.21 | 1289.835801873032 | 352.58 |  | STEP 3) By having defined my model and knowing the variables that explain my model, I can predict my future sales:
month 11 | 61 | 90 | 19 | 12 | 11.48 | 1634.904703086933 | 1163.12 |  | (see formula)
month 12 | 58 | 90 | 19 | 12.2 | 17.06 | 1582.902414987505 | 112.72
month 13 | 59 | 91 | 23 | 11.7 | 8.4 | 1544.115060198948 | 322.7
month 14 | 52 | 89 | 21 | 11.9 | 19.35 | 1540.691998362338 | 255 |  | STEP 4 --> HELP! I want to know "how to understand which is the most import variable, out of those 3 that were detected for the model?"
month 15 | 52 | 89 | 21 | 11.9 | 24.93 | 1499.57377737578 | 202.7
month 16 | 56 | 88 | 23 | 10.8 | 33.56 | 1495.791999533137 | 202.9
month 17 | 55 | 89 | 26 | 11.3 | 59.24 | 1497.562951589676 | 727.56
month 18 | 55 | 89 | 26 | 11.3 | 33.44 | 1238.798928080981 | 321.06
 | 59.16473347964473 |  | 18 |  | 36.3 |  | 377.44
 | 52.22498912617041 |  | 13 |  | 0 |  | 546.21 |  | I want to know which is the most important variable out of those 3
 | 62.52183219073773 |  | 14 |  | 79 |  | 258.44 |  | How can I know?
 | 57.79376122688211 |  | 19 |  | 29.94 |  | 234.88
 | 59.64576498686166 |  | 23 |  | 29.25 |  | 203.98
 | 60.83179101396504 |  | 23 |  | 38.92 |  | 167.56
 | OUTPUT |  |  |  | INPUT
Spreadsheet: 67332d1267958351-toggle-button-for-hiding-unhiding-rows-book3
Sheet: Sheet1

Cost | GL | Description | JANUARY |  |  | YTD
Centre | A/c |  | Budget | Actual | [NAME] | Budget | Actual | [NAME] | 2009 | Balance
 |  | REVENUE
 |  | Hire 1 | 1000000 | 1100000 | 100000 | 1000000 | 1100000 | 100000 | 10000000 | 8900000
 |  | Hire 2 | 1020000 | 1120000 | 100000 | 1020000 | 1120000 | 100000 | 10100000 | 8980000
 |  | Hire 3 | 1040000 | 1140000 | 100000 | 1040000 | 1140000 | 100000 | 10200000 | 9060000
 |  | Hire 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Hire 5 | 1080000 | 1180000 | 100000 | 1080000 | 1180000 | 100000 | 100000 | -1080000
 |  |  | 4140000 | 4540000 | 400000 | 4140000 | 4540000 | 400000 | 30400000 | 25860000
 |  | EXPENSES
 |  | Expenses 1 | 100000 | 110000 | -10000 | 100000 | 110000 | -10000 | 300000 | 190000
 |  | Expenses 2 | 110000 | 120000 | -10000 | 110000 | 120000 | -10000 | 310000 | 190000
 |  | Expenses 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Expenses 4 | 145000 | 140000 | 5000 | 145000 | 140000 | 5000 | 330000 | 190000
 |  | Expenses 5 | 155000 | 150000 | 5000 | 155000 | 150000 | 5000 | 340000 | 190000
 |  | Expenses 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Expenses 7 | 50000 | 70000 | -20000 | 50000 | 70000 | -20000 | 360000 | 290000
 |  | Expenses 8 | 60000 | 80000 | -20000 | 60000 | 80000 | -20000 | 370000 | 290000
 |  | Expenses 9 | 70000 | 90000 | -20000 | 70000 | 90000 | -20000 | 380000 | 290000
 |  | Expenses 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Expenses 11 | 45000 | 35000 | 10000 | 45000 | 35000 | 10000 | 400000 | 365000
 |  | Expenses 12 | 55000 | 45000 | 10000 | 55000 | 45000 | 10000 | 410000 | 365000
 |  | Expenses 13 | 65000 | 55000 | 10000 | 65000 | 55000 | 10000 | 420000 | 365000
 |  | Expenses 14 | 0 | 0 | 0 | 0 | 0 | 0 | 430000 | 430000
 |  | Expenses 15 | 85000 | 75000 |  | 85000 | 75000 | 10000 | 440000 | 365000
 |  | Expenses 16 | 95000 | 85000 | 10000 | 95000 | 85000 | 10000 | 450000 | 365000
 |  | Expenses 17 | 105000 | 95000 | 10000 | 105000 | 95000 | 10000 | 460000 | 365000
 |  |  | 1140000 | 1150000 | -20000 | 1140000 | 1150000 | -10000 | 5400000 | 4250000
 |  | OTHER EXPENSES
 |  | Other expenses 1 | 65000 | 55000 | 10000 | 65000 | 55000 | 10000 | 500000 | 445000
 |  | Other expenses 2 | 75000 | 85000 | -10000 | 75000 | 85000 | -10000 | 550000 | 465000
 |  | Other expenses 3 | 85000 | 75000 | 10000 | 85000 | 75000 | 10000 | 600000 | 525000
 |  | Other expenses 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Other expenses 5 | 105000 | 95000 | 10000 | 105000 | 95000 | 10000 | 700000 | 605000
 |  |  | 330000 | 310000 | 20000 | 330000 | 310000 | 20000 | 2350000 | 2040000
 |  | GRAND TOTAL | 1470000 | 1460000 | 0 | 1470000 | 1460000 | 10000 | 7750000 | 6290000
 |  | NET PROFIT | 2670000 | 3080000 | 410000 | 2670000 | 3080000 | 410000 | 22650000
Spreadsheet: 823695d1680097639-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-r-and-ft-gk3
Sheet: Res 2024

 | RESOURCE TRACKER - YYYY
 | Date | Forecast Days (At Strategise/Shape) | Forecast Days (At Initiate) | Change Requests |  | TOTALS
 |  |  |  | Reference | Days
 | TOTALS
 | RESOURCES |  |  |  |  |  | MONTHLY ALLOCATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 | Name | Business Area | [NAME] | Resource Requested Until | Resource Confirmed Until | Unit Amount | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 |  |  |  |  |  |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | TOTAL FORECAST | TOTAL FORECAST  TO DATE | TOTAL ACTUALS | TOTAL ACTUALS COST | [NAME]
 |  |  | BA Team Managers | JUN | APR | 500 | 2 | 1.2 | 0.5 | 0.7 | 2 | 2.4 | 1.25 | 0.4 | 1 |  | 1 |  | 1
 |  |  | BI Life |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Automation test |  |  |  | 2 | 2.4 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | BillingCenter |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Project Manager |  |  |  | 1 | 1.2 | 2 | 2.4 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MI Tester |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Technical Service Owner |  |  | 500 | 77 | 1.2 | 77 | 0.7 | 77 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MDM |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Print ISIS Papyrus |  |  |  | 0.5 | 0.7 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Test WSL |  |  |  | 1 | 1.3 | 0.5 | 0.7 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 | TOTALS DAYS
 | TOTALS IN £s