tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 11c89d6b-5e48-417a-b586-2d6d111b505d
Sheet: M

Course color corresponds with term of offering. RED  for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Mathematics
MATH 105 | Natural & Mathematical Sciences-Mathematics
MATH 107 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 111 | Natural & Mathematical Sciences-Math Sci other
MATH 113 | Natural & Mathematical Sciences-Math Sci other | Computing
MATH 120 | Natural & Mathematical Sciences-Mathematics
MATH 123 | Natural & Mathematical Sciences-Mathematics
MATH 131 | Natural & Mathematical Sciences-Mathematics
MATH 132 | Natural & Mathematical Sciences-Mathematics
MATH 141 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 142 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 170 | Natural & Mathematical Sciences-Mathematics | Travel; Non-Western
MATH 203 | Natural & Mathematical Sciences-Mathematics | Computing
MATH 220 | Natural & Mathematical Sciences-Mathematics
MATH 270 |  | Experiential-Travel; Non-Western
MATH 415 |  | Capstone
MATH 470 |  | Experiential-Travel
MATH 487 |  | Experiential-Research
MATH 488 |  | Experiential-Research
Music
MUSC 101 | Arts & Literature-Arts
MUSC 110 | Arts & Literature-Arts
MUSC 111 | Arts & Literature-Arts
MUSC 200 | Arts & Literature-Arts
MUSC 210 | Arts & Literature-Arts
MUSC  211 | Arts & Literature-Arts
MUSC 212 | Arts & Literature-Arts
MUSC 215 | Arts & Literature-Arts
MUSC 221 | Arts & Literature-Arts
MUSC 222 | Arts & Literature-Arts
MUSC 230 | Arts & Literature-Arts
MUSC 231 | Arts & Literature-Arts
MUSC 232 | Arts & Literature-Arts
MUSC 240 | Arts & Literature-Arts | Non-Western
MUSC 243 | Arts & Literature-Arts | Experiential-Travel; Non-Western
MUSC 260 | Arts & Literature-Arts
MUSC 270 |  | Computing
MUSC 278 | Arts & Literature-Arts | Experiential-Travel; Experiential-Research
MUSC 301-309 | Arts & Literature-Arts (3 1-hour courses with same course number)
MUSC 310 | Arts & Literature-Arts (3 times at 1 hour)
MUSC 321 | Arts & Literature-Arts
MUSC 322 |  | Computing
MUSC 371 |  | Computing
MUSC 381 | Arts & Literature-Arts | Non-Western | Fall 2013(non-travel) and J-Term 2013(Music of Brazil)
MUSC 381 | Arts & Literature-Arts | Experiential-Travel | J-Term 2014(Choral Music of Greece, Turkey & Italy); J-Term 2010 (Music of the Reformation)
MUSC 420 | Arts & Literature-Arts | Experiential-Research
MUSC 422 | Arts & Literature-Arts | Experiential-Research; Capstone
MUSC 450 |  | Experiential-Internship
Spreadsheet: 159630d1338790199-specialized-sum-formula-example
Sheet: Example

 |  |  |  |  |  | List of Numbers to Sum (With Range K3:O3)-->> |  |  |  | 1 | 3 | 11 | 7 | 7
Quantity of #s to Sum |  |  |  |  |  |  |  |  |  |  |  |  |  | These are the formulas
4 |  |  |  |  |  |  |  |  |  |  |  |  | Sum the last 4 numbers from the above range in this cell (excluding the last number) -->> | 22
3.25 |  |  |  |  |  |  |  |  |  |  |  |  | Sum the last 3.25 numbers from the above range in this cell (i.e. the first three and 1/4 of the fourth) in this cell (excluding the last number) -->> | 21.25
10 |  |  |  |  |  |  |  |  |  |  |  |  | If 10 is more than the numbers in the range, then sum them all (excluding the last number) -->> | 22
0.5 |  |  |  |  |  |  |  |  |  |  |  |  | Since 0.5 is less than 1, just sum that percentage of the last number -->> | 3.5
0 |  |  |  |  |  |  |  |  |  |  |  |  | Since 0 is 0, the answer should be 0 -->> | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | But if I add a blank cell, the formula sums that cell anyway (and counts it as a $0). As a result, these results aren't the same as above. I would like the formula to ignore it.
 |  |  |  |  |  |  |  |  | 1 | 3 |  | 11 | 7 | 7
4 |  |  |  |  |  |  |  |  |  |  |  |  | Sum the last 4 numbers from the above range in this cell (excluding the last number) -->> | 21
3.25 |  |  |  |  |  |  |  |  |  |  |  |  | Sum the last 3.25 numbers from the above range in this cell (i.e. the first three and 1/4 of the fourth) in this cell (excluding the last number) -->> | 18.75
10 |  |  |  |  |  |  |  |  |  |  |  |  | If 10 is more than the numbers in the range, then sum them all (excluding the last number) -->> | 21
0.5 |  |  |  |  |  |  |  |  |  |  |  |  | Since 0.5 is less than 1, just sum that percentage of the last number -->> | 3.5
0 |  |  |  |  |  |  |  |  |  |  |  |  | Since 0 is 0, the answer should be 0 -->> | 0
Spreadsheet: 456469d1460891206-sumproduct-with-range-increment-monthly-sales-report
Sheet: For 2015-16

555
Scheme Type
 | Gross Sales 15-16
 | Our | IND
AF | 8 | 0
B1 | 2.154 | 13.22
B2 | 0 | 0.941
CP | 0 | 0.705
c | 0.001 | 0.181
e1 | 0.005 | 2.346
e2 | 5.647 | 29.034
e3 | 0 | 2.375
e4 | 0 | 0
f1 | 0 | 0.011
f2 | 0 | 0
f3 | 0 | 0.009000000000000001
g1 | 0 | 0
g2 | 0 | 0.011
g3 | 0 | 0.416
i | 0 | 0
m | 0.124 | 1.82
s | 0 | 0.212
u | 0.048 | 0.9159999999999999
Grand Total | 15.979 | 52.197
Spreadsheet: eric_saibi__9888__102301R
Sheet: Ritchie 01

Owner Name |  | Entergy Arkansas Inc.
Station Name |  | [NAME]
Unit Name |  | Unit 01
NERC Region |  | SERC
State |  | AR
Fuel Type |  | Nat. gas / Fuel Oil
Capacity |  | 359 MW
Start Date |  | 2001-11-03 00:00:00
End Date |  | 2001-11-16 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2001-10-18 00:00:00
Comments |  | [NAME] insp.
SIC |  | 4911
Plant ID |  | 1013296
Unit ID |  | 1006242
Outage ID |  | 11773
Spreadsheet: 96307d1295712163-summarizing-data-with-pivot-table-book1
Sheet: Sheet1

 |  |  |  | Country | France
 | Cities | Country |  | Row Labels |  |  |  | IDEALLY I WOULD LIKE TO SEE IT LIKE THIS
 | Paris | France |  | Nice
 | Nice | France |  | Paris |  |  |  | France | UK | USA
 | London | UK |  | Grand Total |  |  |  | Nice | London | Miami
 | [NAME] | UK |  |  |  |  |  | Paris | [NAME] | New York
 | Miami | USA
 | New York | USA
Spreadsheet: 745625d1630065838-breaking-down-a-list-of-supplier-invoices-test
Sheet: Breakdown of Suppliers

 | January | February | March | April | May | June | July | August | September | October | November | December |  |  |  | Balance
Spreadsheet: 12565a67-2057-49bb-8ef9-9ede168d2f70
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Administrative Applications | 1 | Provide user training | None | -- Pick One -- | 1.1.r1 | Class setup | OneTime | 25000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 1 | Provide user training | None | -- Pick One -- | 1.1.r2 | Video Camera | OneTime | 2500 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 3 | Provide current documentation | None | -- Pick One -- | 1.2.r1 | Documentation Specialist | OnGoing | 40000 | 0 | 40000 | 0 | 40000 | 0 | 0 | 0
Administrative Applications | 2 | Publicize provided opportunities | None | -- Pick One --
Administrative Applications | 4 | Permissions maintenance | None | -- Pick One --
Administrative Applications | 2 | Implement structured project management | None | -- Pick One --
Administrative Applications | 3 | Assistive technology | None | -- Pick One -- | 2.2.r1 | MS Project Server | OneTime | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 3 | Assistive technology | None | -- Pick One -- | 2.2.r2 | Project Database | OneTime | 350 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Administrative Applications | 1 | Staff development | None | -- Pick One --
Spreadsheet: 39926d1238166687-looking-up-a-range-of-cells-with-criterias-attached-forum-example
Sheet: Handlers

Agent | Band | Rate | Value
[NAME] | ROI PI | 0.37 | #N/A
[NAME] | IRL NB | 0.26 | #N/A
[NAME] | All-In-One | 0.25 | 1
[NAME] | IRL NB | 0.125 | 0.8
Zak | PEN | 0.12 | 0.8
Spreadsheet: 795946d1663013678-multi-level-parent-summation-bom-type-book4-lucyl-
Sheet: Sheet1

Level | Child Values | Parent / Total SUMS | [NAME]
0 |  | 130
1 |  | 43
2 | 25 | 25
2 |  | 18
3 |  | 18
4 |  | 18
5 | 18 | 18
1 |  | 87
2 | 27 | 27
2 |  | 60
3 | 30 | 30
3 | 30 | 30
0 |  | 148
1 | 26 | 26
1 | 15 | 15
2
2
2
1 | 16 | 16
1 |  | 91
2 | 89 | 89
2 | 1 | 1
2 | 1 | 1
End
Spreadsheet: sally_beck__34326__Cashflow Forecast 12-18r
Sheet: O&M_Detail

OPERATING EXPENSES - Cash Basis
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | 2001-12-31 00:00:00 |  | 2002-01-31 00:00:00 |  | 2002-02-28 00:00:00 |  | 2002-03-31 00:00:00 |  | 2002-04-30 00:00:00 |  | 2002-05-31 00:00:00 |  | 2002-06-30 00:00:00 |  | 2002-07-31 00:00:00 |  | 2002-08-31 00:00:00 |  | 2002-09-30 00:00:00 |  | 2002-10-30 00:00:00 |  | 2002-11-30 00:00:00 |  | 2002-12-31 00:00:00 |  | 2003-01-31 00:00:00 |  | 2003-02-28 00:00:00 |  | 2003-03-31 00:00:00 |  | 2003-04-30 00:00:00 |  | 2003-05-31 00:00:00 |  | 2003-06-30 00:00:00 |  | 19 Months
Headcount
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | 3rd Party Contractors
 |  | Total
Salaries, Wages & Benefits
 | Salaries & Wages
 | Benefits
 |  | Total
Severance
Employee  Expenses
 | Individual and Group Meals - Non-Client
 | Group Entertainment - Non-Client
 | Client and Recruiting Meals & Entertainment
 | Travel-Airfare
 | Travel-Lodging
 | Travel-Meals
 | Travel-Other
 | Other employee expenses
 |  | Total
Outside Services
 | Outside Services-Legal
 | Outside Services-IT
 | Outside Services-Audit
 | Outside Services-Tax
 | Outside Services-Accounting
 | Outside Services-Other
 |  | Total
Technology Expense
 | Computer Expense
 | Other
 |  | Total
Other Operating Expenses
 | Rent (cash exp only)
 | Analyst / Associate Allocation
 | Advertising
 | Communications Expense
 | Supplies & Expenses
 | Subscriptions & Publications
 | Charitable Contributions
 | Other Operating Expenses
 |  | Total
Taxes Other Than Income
 | Payroll Taxes
 | Property Taxes
 | Other Taxes
 |  | Total
(Allocation) to NETco
 | Salaries, Wages & Benefits
 | Employee  Expenses
 | All Other
 |  | Total
TOTAL OPERATING EXPENSES
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: MIS - CS-SPD BULK #2

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD BULK #2
FACILITY: | MISERICORDIA
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X | X
 | *NO STAT HOLIDAYS
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
100-HUCK TOWEL |  |  |  | BP0010 |  | 1
20-WRAPPER 18" |  |  |  | BP0002 |  | 4
20-WRAPPER 24" |  |  |  | BP0003 |  | 3
20-WRAPPER 30" |  |  |  | BP0004 |  | 3
20-WRAPPER 36" |  |  |  | BP0005 |  | 3
20-WRAPPER 45" |  |  |  | BP0006 |  | 5
20-WRAPPER 54" |  |  |  | BP0007 |  | 3
5-SM FEN DRAPES |  |  |  | BP0018 |  | 12
5-ISO GOWN GREEN |  |  |  | GL0010 |  | 5
UPDATED:
June 17th 2009
Spreadsheet: 32584d1228771090-complex-if-statement-wewt
Sheet: Payables

Sort Data By:
BILL DATA |  |  |  |  |  |  |  |  |  |  | Payment Plan |  |  |  |  |  |  |  |  |  | 1st Wk Ending | 2nd Wk Ending | 3rd Wk Ending | 4th Wk Ending | 5th Wk Ending | 6th Wk Ending | 7th Wk Ending | 8th Wk Ending | 9th Wk Ending | 10th Wk Ending | 11th Wk Ending | 12th Wk Ending | 13th Wk Ending | 14th Wk Ending | 15th Wk Ending | 16th Wk Ending | 17th Wk Ending | 18th Wk Ending | 19th Wk Ending | 20th Wk Ending | 21st Wk Ending | 22nd Wk Ending | 23rd Wk Ending | 24th Wk Ending | 25th Wk Ending | 26th Wk Ending
Accounts Payable | Paid | [NAME] | [NAME] | Amt (Bal) | Terms | [NAME] | Due | Planned to | [NAME] | Plann'd | Payment | Amount | Payment | Amount | Payment | Amount | Payment | Amount | Balance
Vendor Names | ("X") | Date | No. | Due |  | Status | Date | Pay Date | Aging | Aging | Date |  | Date |  | Date |  | Date |  |  |  | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated
Accounts Payable
ICC Warrenty |  | 2008-09-01 00:00:00 | 6 | 15000 | 30 |  |  | 2008-10-05 00:00:00 |  |  | 2008-10-10 00:00:00 | 2000 | 2008-10-17 00:00:00 | 3000 | 2008-10-25 00:00:00 | 4000 | 2008-10-31 00:00:00 | 6000
Jonesville equip. backcharges |  | 2008-10-15 00:00:00 | 7 | 2000 | 45
ICC Warrenty |  | 2008-10-25 00:00:00 | 5 | 4250 | 15 |  | 2008-11-13 00:00:00
East Noble Schools |  | 2008-08-15 00:00:00 | 4 | 5000 | 30 |  |  | 2008-10-20 00:00:00
Deam Lake |  | 2008-08-01 00:00:00 | 2 | 15000 | 60 |  |  | 2008-10-10 00:00:00
Spreadsheet: 139066d1328053909-i-need-help-with-array-formula-index-match-match-table
Sheet: Sheet1

 | HEIGHT | WIDTH |  |  |  |  |  | HEIGHT | WIDTH
 |  | 10" - 14" | 14" - 18" | 18" - 22" | 22" - 26" | 26" - 30"
 |  | 10" | 14" | 18" | 22" | 26" |  |  | 10" | 14" | 18" | 22" | 26"
20" - 36" | 20" | 130 | 160 | 200 | 240 | 280 |  | 20" | 138 | 173 | 215 | 259 | 301
36" - 42" | 36" | 140 | 180 | 220 | 265 | 310 |  | 36" | 153 | 191 | 237 | 284 | 329
42" - 48" | 42" | 160 | 195 | 240 | 290 | 335 |  | 42" | 168 | 209 | 259 | 309 | 358
48" - 54" | 48" | 170 | 215 | 260 | 310 | 360 |  | 48" | 180 | 227 | 280 | 334 | 386
54" - 60" | 54" | 180 | 230 | 280 | 335 | 385 |  | 54" | 195 | 245 | 302 | 359 | 414
60" - 66" | 60" | 195 | 245 | 300 | 360 | 415 |  | 60" | 210 | 263 | 323 | 384 | 442
66" - 72" | 66" | 210 | 260 | 320 | 380 | 440 |  | 66" | 225 | 281 | 345 | 409 | 471
72" - 78" | 72" | 225 | 280 | 340 | 405 | 465 |  | 72" | 240 | 299 | 367 | 434 | 499
78" - 84" | 78" | 240 | 295 | 360 | 430 | 490 |  | 78" | 255 | 317 | 388 | 459 | 527
84" - 90" | 84" | 245 | 315 | 380 | 450 | 520 |  | 84" | 262 | 335 | 410 | 484 | 555
90" - 96" | 90" | 265 | 330 | 400 | 475 | 545 |  | 90" | 270 | 353 | 431 | 509 | 584
96" - 102" | 96" | 280 | 345 | 420 | 495 | 570 |  | 96" | 285 | 371 | 453 | 534 | 612
 |  | HEIGHT | WIDTH | RATE |  |  |  |  |  | HEIGHT | WIDTH | RATE
 |  | 79" | 25" | 430 |  |  |  |  |  | 79" | 25" | 459
 | HEIGHT | WIDTH |  |  |  |  |  | HEIGHT | WIDTH
 |  | 10" - 14" | 14" - 18" | 18" - 22" | 22" - 26" | 26" - 30" |  |  | 10" - 14" | 14" - 18" | 18" - 22" | 22" - 26" | 26" - 30"
 | 20" - 36" | 178.69 | 224.08 | 279.93 | 336.24 | 391.2 |  | 20" - 36" | 142.952 | 179.264 | 223.944 | 268.992 | 312.96
 | 36" - 42" | 198.48 | 247.55 | 307.97 | 368.72 | 427.87 |  | 36" - 42" | 158.784 | 198.04 | 246.376 | 294.9760000000001 | 342.296
 | 42" - 48" | 218.27 | 271.02 | 336.01 | 401.2 | 464.53 |  | 42" - 48" | 174.616 | 216.816 | 268.808 | 320.96 | 371.624
 | 48" - 54" | 233.86 | 294.49 | 364.05 | 433.68 | 501.19 |  | 48" - 54" | 187.088 | 235.592 | 291.24 | 346.944 | 400.952
 | 54" - 60" | 253.3 | 317.96 | 392.09 | 466.16 | 537.86 |  | 54" - 60" | 202.64 | 254.368 | 313.672 | 372.9280000000001 | 430.288
 | 60" - 66" | 272.74 | 341.43 | 420.13 | 498.64 | 574.52 |  | 60" - 66" | 218.192 | 273.144 | 336.104 | 398.912 | 459.616
 | 66" - 72" | 292.19 | 364.9 | 448.17 | 531.12 | 611.19 |  | 66" - 72" | 233.752 | 291.92 | 358.5360000000001 | 424.896 | 488.9520000000001
 | 72" - 78" | 311.63 | 388.37 | 476.21 | 563.59 | 647.85 |  | 72" - 78" | 249.304 | 310.696 | 380.968 | 450.8720000000001 | 518.28
 | 78" - 84" | 331.07 | 411.84 | 504.25 | 596.07 | 684.52 |  | 78" - 84" | 264.856 | 329.472 | 403.4 | 476.8560000000001 | 547.616
 | 84" - 90" | 340.14 | 435.31 | 532.29 | 628.55 | 721.18 |  | 84" - 90" | 272.112 | 348.248 | 425.832 | 502.84 | 576.944
 | 90" - 96" | 350.59 | 458.78 | 560.34 | 661.03 | 757.84 |  | 90" - 96" | 280.472 | 367.024 | 448.272 | 528.824 | 606.272
 | 96" - 102" | 370.03 | 482.25 | 588.38 | 693.51 | 794.51 |  | 96" - 102" | 296.024 | 385.8 | 470.704 | 554.808 | 635.6080000000001
Spreadsheet: 887252d1737495417-streamlining-data-collection-for-making-tables-and-charts-example
Sheet: Data

Date | Vehicle | Distance | Destination
2024-01-15 00:00:00 | Car 2 | 20 | Location 1
2024-01-16 00:00:00 | Van 2 | 13 | Location 2
2024-01-17 00:00:00 | Truck1 | 25 | Location 3
2024-01-18 00:00:00 | Truck 2 | 14 | Location 4
2024-01-19 00:00:00 | Bus 1 | 23 | Location 5
2024-01-20 00:00:00 | Big Bus 1 | 62 | Location 6
2024-01-21 00:00:00 | Van 1 | 10 | Location 7
2024-02-05 00:00:00 | Van 2 | 3 | Location 8
2024-02-06 00:00:00 | Van 1 | 52 | Location 5
2024-02-07 00:00:00 | Car 1 | 15 | Location 3
2024-02-08 00:00:00 | Car 2 | 36 | Location 3
2024-02-09 00:00:00 | Truck 3 | 15 | Location 12
2024-02-10 00:00:00 | Truck 2 | 24 | Location 11
2024-02-11 00:00:00 | Car 1 | 23 | Location 7
2024-02-12 00:00:00 | Bus 1 | 36 | Location 3
2024-02-13 00:00:00 | Truck1 | 25 | Location 1
2024-02-14 00:00:00 | Car 2 | 21 | Location 2
2024-02-15 00:00:00 | Van 2 | 52 | Location 13
2024-03-20 00:00:00 | Van 1 | 41 | Location 5
2024-03-21 00:00:00 | Truck 2 | 23 | Location 10
2024-03-22 00:00:00 | Big Bus 1 | 12 | Location 9
2024-03-23 00:00:00 | Big Bus 1 | 30 | Location 6
2024-03-24 00:00:00 | Big Bus 1 | 20 | Location 6
2024-03-25 00:00:00 | Truck1 | 10 | Location 11
2024-04-21 00:00:00 | Car 2 | 60 | Location 11
2024-04-22 00:00:00 | Car 1 | 42 | Location 7
2024-04-23 00:00:00 | Van 2 | 15 | Location 7
2024-04-24 00:00:00 | Van 2 | 35 | Location 7
2024-04-25 00:00:00 | Van 2 | 14 | Location 3
2024-04-26 00:00:00 | Truck1 | 22 | Location 11
Spreadsheet: 881109d1729021693-calculating-number-of-winter-workdays-between-two-dats-revised-structural-erection-worksheet-test
Sheet: Man Hour Calculator

Quantity Calculator
Unload |  |  | Ea | Shake Out |  |  | Ea |  | Production Rates
Qty of Beams |  | 500 | Ea | Qty over 30 |  |  | Ea
Qty of Columns |  | 500 | Ea | Qty over 30 |  |  | Ea |  |  | Unload |  |  | 30 | Shake Out |  |  | 15
Pandecking |  | 500 | SqFt | Qty over 30 |  |  | SqFt |  |  | Erection Under 30 |  |  | 0.875 | Erection over 30 |  |  | 0.8
Qty of Studs |  |  | Ea | Qty over 30 |  |  | Ea |  |  | Decking under 30 |  |  | 90 | Decking over 30 |  |  | 75
Qty of Bolts |  |  | Ea | Qty over 30 |  |  | Ea |  |  | Welding Under 30 |  |  | 4 | Welding Over 30 |  |  | 3
Welding |  |  | LF | Qty over 30 |  |  | LF |  |  | Stud Welding Under 30 |  |  | 30 | Stud Welding Over 30 |  |  | 23
Wall Panels |  |  | Ea | Qty over 30 |  |  | Ea |  |  | [NAME] Up Under 30 |  |  | 16 | Bolt Up Over 30 |  |  | 12
[NAME] |  |  | Ea | Qty over 30 |  |  | Ea |  |  | Wall Panels Under 30 |  |  | 0.5 | Wall Panels Over 30 |  |  | 0.25
Total Units
Man Hours |  |  |  |  |  |  |  |  |  | [NAME] Under 30 |  |  | 0.5 | [NAME] Over 30 |  |  | 0.25
Unload |  |  |  | Shake Out |  |  |  |  |  | Plumbing |  |  | 1 | Plumbing over 30 |  |  | 1
Erection Under 30 |  |  |  | Erection over 30 |  |  |  |  |  | Misc |  |  | 1 | Misc Over 30 |  |  | 1
Decking under 30 |  |  |  | Decking over 30
Welding Under 30 |  |  |  | Welding Over 30
Stud Welding Under 30 |  |  |  | Stud Welding Over 30
[NAME] Up Under 30 |  |  |  | Bolt Up Over 30
Wall Panels Under 30 |  |  |  | Wall Panels Over 30
[NAME] Under 30 |  |  |  | [NAME] Over 30
Plumbing |  |  |  | Plumbing over 30
Misc |  |  |  | Misc Over 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Period Start |  |  | Winter Start |  | 2024-11-01 00:00:00
Total Hours: |  |  |  | Winter Hours |  |  |  |  |  |  |  |  |  | Period End |  |  | Winter End |  | 2025-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winter Period Days
[NAME] |  | 100 | Ea | Onsite days |  |  | Days
Man hours per Day |  | 9 |  | Job Duration |  |  | Days
Work Days per Week |  | 6 |  | Schedule Duration |  |  | Weeks
 |  |  |  |  |  |  | Months |  |  |  |  |  |  |  |  |  | 1st Winter Start
Crew Hours Per Day |  |  |  | Start Date: | 2024-12-01 00:00:00 | End Date |  |  |  |  |  |  |  |  |  |  | last winter end
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No complete [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winter Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winter Working Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Composite [NAME]
Spreadsheet: 76189d1276722847-breaking-up-data-across-multiple-worksheets-np-transactions_5-29-10_1test
Sheet: data

CARMICM | 0 | 0 | 1
FREEMAJ2 | 1 | 0 | 1
NORMANS | 1 | 1 | 1
 | 2 | 1 | 1
 | 3 | 1 | 1
 | 3 | 2 | 1
 | 4 | 2 | 1
 | 5 | 2 | 1
 | 6 | 2 | 1
 | 6 | 2 | 2
 | 7 | 2 | 2
 | 7 | 3 | 2
 | 7 | 3 | 3
 | 7 | 3 | 4
 | 8 | 3 | 4
 | 9 | 3 | 4
 | 10 | 3 | 4
 | 10 | 4 | 4
 | 10 | 5 | 4
 | 10 | 6 | 4
 | 11 | 6 | 4
 | 11 | 7 | 4
 | 11 | 7 | 5
 | 11 | 7 | 6
 | 11 | 8 | 6
 | 11 | 9 | 6
 | 11 | 10 | 6
 | 11 | 11 | 6
 | 12 | 11 | 6
 | 12 | 11 | 7
 | 12 | 12 | 7
 | 13 | 12 | 7
 | 14 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
 | 15 | 12 | 7
Spreadsheet: 713392d1610690643-countif-to-record-win-or-loss-in-3-cells-in-a-row-14-25-36
Sheet: Sheet1

 |  | # |  | 14 | 25 | 36
36
7
8
12
0
33
36
1
12
18
19
16
4
7
31
26
22
19
8
11
Spreadsheet: james_steffes__12836__m010808
Sheet: Sheet1

2001-07-22 00:00:00
USD MLNS | PG&E | EDISON | SDG&E | TOTAL |  | PG&E | EDISON | SDG&E | TOTAL
1Q 2001 | 105.118 | 97.826 | 36.661
2Q 2001 | 382.142 | 339.55 | 125.573
3Q 2001 | 612.808 | 844.55 | 323.692
4Q 2001 | 1031.244 | 889.777 | 341.389
1Q 2002 | 924.185 | 785.71 | 327.899
2Q 2002 | 583.401 | 1001.12 | 329.53
3Q 2002 | 695.644 | 1074.418 | 317.196
4Q 2002 | 863.144 | 770.324 | 269.027
Total
2001-08-07 00:00:00
USD MLNS | PG&E | EDISON | SDG&E | TOTAL |  | PG&E | EDISON | SDG&E | TOTAL
1Q 2001 | 542.003 | 256.462 | 73.563
2Q 2001 | 1319.835 | 556.693 | 218.302
3Q 2001 | 719.188 | 712.687 | 277.91
4Q 2001 | 780.906 | 561.608 | 267.09
1Q 2002 | 691.501 | 466.361 | 286.06
2Q 2002 | 452.819 | 662.416 | 302.846
3Q 2002 | 639.895 | 825.979 | 340.6
4Q 2002 | 781.635 | 561.954 | 302.071
Total
DELTA
USD MLNS | PG&E | EDISON | SDG&E | TOTAL |  | PG&E | EDISON | SDG&E | TOTAL
1Q 2001
2Q 2001
3Q 2001
4Q 2001
1Q 2002
2Q 2002
3Q 2002
4Q 2002
Total