tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1178__ENRON_$orion_1099
Sheet: Construction Costs

 |  |  |  |  |  |  |  |  | Project Orion
Summary of Project Costs (Plant 1)
 |  |  |  | Summary
Source |  | [NAME] |  | Land
Date |  | 1999-10-28 00:00:00 |  | EPC
 |  |  |  | Management's Costs
 |  |  |  | Total Project Cost
EPC
Major Equipment |  |  |  | Construction Services (Cont.)
 | Gas Turbines |  |  | Structural Steel | 184352
 | Heat Recovery Boilers | 16500000 |  | Building and Erection | 1469386
 | Steam Turbines | 13044000 |  | Equipment Installation - Mechanical | 2267166
 | Freight |  |  | Process Piping | 2924272
 | Total Major Equipment |  |  | Equipment Installation - Electrical | 1252755
Balance of Plant Equipment and Materials |  |  |  | Electrical - Wire, Cable & Terminati | 1857267
 | Electrical [NAME]  and [NAME] | 9149264 |  | Testing, Calibration | 558253
 | Instrumentation and Controls | 2504816 |  | Site Interconnections Eng. & Construction | 3000000
 | Conduit, Wire and Cable | 1629954 |  | Total Construction Services
 | [NAME] | 1072154
 | Pumps | 1703479 |  | Change Orders/Contingency | 9200000
 | Misc. Equipment | 2561965
 | Condeners | 1541818 |  | Engineering | 6699886
 | Natural Gas Sample and [NAME] | 1284351 |  | Total EPC
 | [NAME] | 1226330
 | Piping | 2825306 |  | Managment's Costs
 | Valves | 1467092
 | Total Plant Equipment and Materials |  |  | Project Management, Expenses and Devel't Fees | 20816248
Construction Services |  |  |  | O&M Start Up Personnel and Expenses | 5146668
 | General [NAME]. [NAME] And Pro. | 12787938 |  | Spare Parts | 4000000
 | Field Office Expenses | 1010152 |  | Insurance | 2167996
 | Field Office Personnel | 2377536 |  | Allowance for Sales and Use Tax | 6185792
 | Misc. General [NAME] | 920640 |  | Total Management's Costs
 | Electrical Subcontractor Indirects | 6181618
 | Construction Equipment | 2962547 |  | Total Plant Costs
 | Mobilization | 1004000
 | Site Development | 2043358 |  | Land | 5000000
 | Foundations | 4395994
Spreadsheet: daren_farmer__6563__egmnom-Feb
Sheet: EGM 60

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-207106-02-010
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-02-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-02-29 00:00:00
RECEIPTS |  |  | FEB
METER # | [NAME] | SUPPLIER | 1
644 | LONE STAR KATY | DUKE
644 | LONE STAR KATY | RICHARDSON | 0
4132 | EXXON KATY | ECT | 5000
4132 | EXXON KATY | COKINOS | 0
XXXX | IMBALANCE | ENTEX/HPL | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
1563 | COGEN | DYNEGY | 0
1373 | [NAME] | CES | 0
1485 | OXY BATTLEGROUND | OXY
1505 | DEER PARK | DUPONT | 0
1506 | RHOM & HAAS DEER PARK | RHOM & HAAS | 0
1394 | HILL PETRO | DYNEGY | 0
8001 | AIR LIQUIDE | AIR LIQUIDE | 10000
XXXX | IMBALANCE | ENTEX/HPL | 0
 |  | DELIVERY TOTAL
Spreadsheet: 735087d1622689547-summary-of-hours-spent-on-the-projects-book2
Sheet: Weekly_

Date
 |  | Meeting | Tech Services |  | Meeting | Tech Services | NLR | Mourya Bypass | Picton | Milton
 |  | 2 | 2.5
 | NLR | Mourya Bypass | Picton
 | 3 | 3 | 2
 | Mourya Bypass | Tech Services | NLR
 | 3 | 1 | 4
 | Picton | Tech Services | Milton
 | 5 | 2 | 1
 | Milton | Tech Services
 | 4 | 1
Spreadsheet: 35617d1233194770-excel-2007-can-excel-take-a-word-and-convert-it-to-a-number-qc-sheet-master-1
Sheet: Weekly Review

 |  |  |  |  |  |  |  | Weekly QC Report
 |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00 | Thru
 |  |  |  |  |  |  |  | System: | Scranton
 | Technician |  |  |  | Days off | Jobs Routed | [NAME] | Jobs Not Completed | Work Completion % | QC % of Completed Work | Total QC Completed | QC % Break Down by [NAME] | Pass | Fail | QC Failure % By [NAME]
 | 1 | 1
 | 2 | 2
 | 3 | 3
 | 4 | 4
 | 5 | 5
 | 6 | 6
 | 7 | 7
 | 8 | 8
 | 9 | 9
 | 10 | 10
 | 11 | 11
 | 12 | 12
 | 13 | 13
 | 14 | 14
 | 15 | 15
 | 16 | 16
 | 17 | 17
 | 18 | 18
 | 19 | 19
 | 20 | 20
 | 21 | 21
 | 22 | 22
 | 23 | 23
 | 24 | 24
 | 25 | 25
 | Totals |  |  |  |  | Total Jobs | Completed | Not Completed | Total Comp % | Work QC'd Total | Total QC's Completed |  | Pass | Fail | QC Failure % Average
Spreadsheet: 680197d1590852562-index-match-with-3-criteria-index-match_match-type
Sheet: Sheet1

 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00
djnc | haha | 12 | 34 | 56 | 98 | 85
oinc | hehe | 78 | 89 | 910 | 54 | 52
wsnc | hoho | 1112 | 1314 | 1516 | 321 | 63
 |  | Index Match |  | [NAME]
Greather than
criteria 1 | haha
criteria 2 | 2020-04-01 00:00:00
Exact
criteria 1 | haha
criteria 2 | 2020-03-31 00:00:00
Less than
criteria 1 | haha
criteria 2 | djnc
criteria 3 | 2020-03-30 00:00:00
Spreadsheet: 715663d1611821511-understanding-the-lookup-formula-forum-excel-22-jan-2021
Sheet: Épargnes Inv.

 |  |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
 |  |  | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
 | Solde actuel des comptes: | AR
 |  | FT
 |  | PL
 |  | UR
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-01-10 00:00:00 | Deposit | AR | 200
2020-01-21 00:00:00 | Deposit | AR | 200
2020-01-30 00:00:00 | Deposit | AR | 200
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-01 00:00:00 | Deposit | AR | 25
2020-03-05 00:00:00 | Withdrawal | AR | -30
2020-03-11 00:00:00 | Withdrawal | FT | -45
2020-03-13 00:00:00 | Withdrawal | AR | 20
2020-03-01 00:00:00 | Deposit | PL | 60
2020-03-01 00:00:00 | Deposit | UR | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 0 | 230 |  | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | PL | 0 | 320 |  | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 0 | 55 |  | 65
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 0 | 77 |  | 77
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-06-15 00:00:00 | Withdrawal | PL | -40
2020-06-15 00:00:00 | Withdrawal | UR | -70
2021-01-01 00:00:00 | Deposit | AR | 120
2021-01-01 00:00:00 | Deposit | FT | 100
2021-01-01 00:00:00 | Deposit | PL | 90
2021-01-01 00:00:00 | Deposit | UR | 80
Spreadsheet: 777463d1650393365-pulling-header-names-where-time-worked-equals-0-timesheets-help-example
Sheet: TechHrs

 | PAYROLL PERIOD: | 2022-03-14 00:00:00 |  |  | THRU
Tech # | Employee Name | MON | TUE | WED | THR | FRI | SAT | SUN | Total Hours
1 | Employee 1 | 9.1 | 10.48333333333333 | 0.4166666666666667 | EAB | 9.549999999999999
2 | Employee 2 | 8 | 7.616666666666666 | 8.266666666666666 | 9.366666666666667 | 6.200000000000001
3 | Employee 3 | 7.9 | 8.683333333333334 | 7.616666666666666 | 9.116666666666667 | 6.600000000000001 | 2
4 | Employee 4 | 10.71666666666667 | 10 | 9.933333333333334 | 10.38333333333333
6 | Employee 5 | USD | 8.100000000000001 | 9.783333333333333 | 9.200000000000001 | 8.2 | 7.1
23
24
25
Spreadsheet: 843561d1695333528-creating-a-table-with-variable-values-based-on-dropdown-selection-copy-of-sample-data-
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | Vendor 1 | 10 | 12 | 18 | 19 |  |  | Material 1 | 10 | 40 | 70 | 100
 |  | Vendor 2 | 10 | 10 | 10 | 10 |  |  | Material 2 | 20 | 50 | 80 | 110
 |  | Vendor 3 | 11 | 11 | 11 | 11 |  |  | Material 3 | 30 | 60 | 90 | 20
 |  |  |  |  |  |  |  |  | Material | Material 3 | The table values would change based on the drop down selections
 |  |  |  |  |  |  |  |  | Vendor | Vendor 2
 |  | Car 1 |  |  |  |  |  |  | Car | Car 2
 | Demand Plan |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
 |  | CANADA | 20 |  |  |  |  |  | USA
 |  | Mexico | 30 |  |  |  |  |  | CANADA
 |  |  |  |  |  |  |  |  | Mexico
 |  | Car 2
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA
 |  | Mexico
 |  | Car 3
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA
 |  | Mexico
 | APP | [NAME] | MS | PD | HMY
 | Material 1
 | Material 2
 | Material 3
 | Material 4 | 0.0007 | 0 | 0.035 | 0.08988
 | Material 5 | 30 | 0 | 80 | 72
 | Material 6
 | Material 7
 | Material 8
 | AS | [NAME] | MS | PD | HMY
 | Material 1
 | Material 2
 | Material 3
 | Material 4
 | Material 5
 | Material 6
 | Material 7
 | Material 8
Spreadsheet: 77425d1277905968-duplicates-based-on-multiple-columns-dummy-file
Sheet: Apple

APPLE
Spreadsheet: 86542d1286498080-find-group-and-sum-by-each-dummy-sample-b
Sheet: Projects Charged

Name | Proj ID | Totals
[NAME] | 55555 | 34
[NAME] | 121212 | 44
[NAME] | 434343 | 2132
[NAME] | 55555 | 335
[NAME] | 434356 | 54
[NAME] | 121212 | 456
Mart Doe | 55555 | 657
Spreadsheet: daren_farmer__5485__hpl0920
Sheet: Sheet1

HPLN0920.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 20, 2000
 |  |  |  |  |  | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-20 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
 |  | 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: 61638d1262589005-combined-and-summary-combine-and-summary-sales-help-sumifs-sumproduct-
Sheet: Summary_SUMPRODUCT

ABC Company Sales Report for January 2010
Company Name | 1st Week | 2nd Week | 3rd Week | 4th Week | Total
 | 1st - 9th Jan | 10th - 16th | 17th - 23th | 24th - 31st |  |  |  | 1 | 10 | 17 | 24 | 31
 |  |  |  |  |  |  |  | 2010-01-01 00:00:00 | 2010-01-10 00:00:00 | 2010-01-17 00:00:00 | 2010-01-24 00:00:00 | 2010-02-01 00:00:00
WZT Technology | 500 | 0 | 600 | 0 | 1100
LKT Co., Ltd | 880 | 0 | 0 | 0 | 880
Titanic Trading | 0 | 0 | 600 | 1410 | 2010
 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0
Total | 1380 | 0 | 1200 | 1410 | 3990
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 2-5T

 | Section 2: Inventory
 | Table 2-5Trend: Passenger Vehicles by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Low-Speed Electric Vehicle | 0 | 3029 | 3869 | 3893 | 3729
 | Subcompact | 5935 | 6797 | 10658 | 13867 | 20368
 | Compact | 36662 | 46489 | 49657 | 47999 | 41564
 | Midsize | 57284 | 48242 | 38057 | 33321 | 30659
 | Large | 10230 | 10063 | 9146 | 8571 | 6753
 | Limousines | 349 | 412 | 158 | 130 | 123
 | Light Duty Passenger Vans | 41855 | 41676 | 40964 | 39518 | 38409
 | Medium Duty Passenger Vans | 15362 | 15218 | 16633 | 15740 | 14115
 | Light Duty SUVs | 64793 | 66316 | 68807 | 73356 | 70371
 | Medium Duty SUVs | 7344 | 11117 | 11448 | 9405 | 9533
 | Grand Total | 239814 | 249359 | 249397 | 245800 | 235624
Spreadsheet: 748565d1632218401-top-three-data-with-xlookup-fb-sheet
Sheet: Sheet1

Product | Cust | QTY
urea | A1 | 0
urea | B1 | 10 |  |  |  |  |  |  |  | Row Labels | Sum of QTY
urea | A2 | 5 |  | DAP |  |  |  |  |  | DAP | 565
urea | A3 | 100 |  | TOP1 |  |  |  |  |  | A1 | 85
urea | A1 | 55 |  | TOP2 |  |  |  |  |  | A2 | 20
urea | B2 | 1 |  | TOP3 |  |  |  |  |  | A4 | 10
urea | A4 | 99 |  |  |  |  |  |  |  | A5 | 80
DAP | A5 | 80 |  |  |  |  |  |  |  | A6 | 74
DAP | A6 | 74 |  | Urea |  |  |  |  |  | B1 | 65
DAP | C1 | 108 |  | TOP1 |  |  |  |  |  | C1 | 108
DAP | C2 | 110 |  | TOP2 |  |  |  |  |  | C2 | 110
DAP | [NAME] | 13 |  | TOP3 |  |  |  |  |  | [NAME] | 13
urea | A4 | 17 |  |  |  |  |  |  |  | urea | 386
DAP | A4 | 10 |  |  |  |  |  |  |  | A1 | 60
urea | C2 | 15 |  |  |  |  |  |  |  | A2 | 84
DAP | A2 | 20 |  |  |  |  |  |  |  | A3 | 100
urea | A2 | 79 |  |  |  |  |  |  |  | A4 | 116
DAP | A1 | 85 |  |  |  |  |  |  |  | B1 | 10
DAP | B1 | 65 |  |  |  |  |  |  |  | B2 | 1
urea | A1 | 5 |  |  |  |  |  |  |  | C2 | 15
DAP | d | 2 |  |  |  |  |  |  |  | (blank)
DAP | f | 23 |  |  |  |  |  |  |  | Grand Total | 951
DAP | h | 65
DAP | kr | 3
DAP | s | 31
DAP | j | 4
DAP | v | 314
Spreadsheet: 79048d1279278827-disappearing-info-advanced-filters-running-down-the-page-with-macro-new-cost-centre-system-forumex
Sheet: Q1307

Cost Centre
Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 701 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 702 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 703
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B |  |  |  |  |  | Cost Centre | Activity Code | Party Id | Name | Service Start | Service End | Frequency | Rate | Provider | A / B
Spreadsheet: 682449d1592116846-any-trick-to-make-data-label-appear-when-it-is-off-the-chart-label_issue
Sheet: Sheet1

Sum of Number | Column Labels
Row Labels | Clothes | Toys | Grand Total |  | Original Scale (700) |  |  |  |  |  |  |  | Adjusted Scale (200). However, the label (600) for Dept B is not shown, is there a way to show the label in the bar besides changing the positon to inside base? Would also like to avoid textbox, as when using slicer to filter dept, the position of the bar will change accordingly.
A | 50 | 10 | 60
B |  | 600 | 600
C | 50 | 10 | 60
D | 120 | 10 | 130
E | 60 | 10 | 70
F | 10 |  | 10
G | 80 | 10 | 90
H | 10 | 50 | 60
I | 10 |  | 10
J |  | 20 | 20
K | 50 | 100 | 150
Grand Total | 440 | 820 | 1260
Spreadsheet: 862562d1710254942-copying-data-from-one-sheet-to-another-book1
Sheet: Sheet2

 |  |  | Tammsaare teenindus | Dokumentide [NAME] | [NAME] politseijaoskond | [NAME] politseijaoskond | Viljandi politseijaoskond, [NAME] | Jõgeva politseijaoskond ja Jõgeva teenindus | [NAME] politseijaoskond [NAME] ning Põlva teenindus | [NAME] politseijaoskond [NAME], Valga teenindus ning arestimaja | Kagu politseijaoskond Võrus, Võru teenindus ja arestimaja | [NAME] politseijaoskond ning teenindus | Rakvere politseijaoskond, [NAME] | Narva politseijaoskond, teenindus ning arestimaja | Pärnu politseijaoskond, [NAME] | Kesk-Eesti politseijaoskond Paides, Paide teenindus ja arestimaja | Kesk-Eesti politseijaoskond [NAME], Rapla teenindus ja arestimaja | Haapsalu politseijaoskond, [NAME] | Kuressaare politseijaoskond, teenindus ning arestimaja | Kärdla politseijaoskond, [NAME] | [NAME] piiripunkt | Narva 2 piiripunkt | Luhamaa piiripunkt | Narva piiripunkt | Saatse piiripunkt | [NAME] raudteepiiripunkt | Tallinna lennujaama piiripunkt | Tallinna sadama piiripunkt
1 | INF.1.M2 Elektrisüsteemi sobivus | INF.1.M2 Elektrisüsteemi sobivus
1 |  | [NAME] tehnilised parameetrid vastavad tegelikele vajadustele. |  |  |  |  |  |  |  |  |  |  |  |  | Rakendatud
1 |  | [NAME] tarbitav võimsus jaotub ühtlaselt vooluvõrgu kolme faasi vahel. |  |  |  |  |  |  |  |  |  |  |  |  | Rakendatud
1 |  | [NAME] ja kaitsmed vastavad juhistiku projektile. |  |  |  |  |  |  |  |  |  |  |  |  | Rakendatud
1 |  | d. Ruumide kasutuse ja tehnilise varustuse (IT, kliimaseadmete, valgustuse jms) [NAME] ja vajadusel kohandatakse elektrisüsteemi. |  |  |  |  | Rakendatud | Rakendatud | Rakendatud | Rakendatud | Rakendatud |  |  |  | Rakendatud |  |  |  |  |  | Rakendatud |  | Rakendatud |  | Rakendatud | Rakendatud
1 |  | INF.1.M10 Standardite ja eeskirjade järgimine [haldusosakond]
1 |  | [NAME], rajamisel, sisustamisel, remontimisel ning tehnosüsteemide paigaldamisel järgitakse kohaldatavaid ehitusnorme. |  |  |  |  | Rakendatud | Rakendatud | Rakendatud | Rakendatud | Rakendatud |  |  |  |  |  |  |  |  |  | Rakendatud |  | Rakendatud |  | Rakendatud | Rakendatud
Spreadsheet: 503213d1487678226-looking-for-a-formula-to-convert-american-dates-to-british-dates-example
Sheet: Sheet1

Raw Date
42593.44815972223
11/15/2016 2:22:12 PM
9/21/2016 11:44:13 AM
42593.49517361111
10/31/2016 11:20:42 AM
10/31/2016 11:20:42 AM
9/21/2016 5:23:52 PM
9/22/2016 9:09:40 AM
9/27/2016 9:40:23 AM
9/20/2016 1:38:48 PM
42561.51969907407
8/30/2016 10:24:05 AM
10/27/2016 1:51:17 PM
42653.51061342593
Spreadsheet: 0bfb4edc-278d-449b-babb-881996f16fc5
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
 | 8731.0 Building Approvals, Australia
 | TABLE 79. Value of Building Approved, Chain Volume Measures, Original - Western Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total houses ;  New ; |  |  | Original | A590517J | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total other residential building ;  New ; |  |  | Original | A590518K | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  New ; |  |  | Original | A590519L | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590520W | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590521X | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590522A | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590523C | 1985-09-01 00:00:00 | 2011-03-01 00:00:00 | 103 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 703272d1604922500-old-text-to-new-text-for-bh
Sheet: BH Sheet

 |  |  | Old TP | New TP Result Required
10 | 750 | BH-04 | 1TP1 | TP3666
11 | 750 | BH-04 | 1TP1 | TP3666
12 | 750 | BH-04 | 1TP1 | TP3666
13 | 1000 | BH-05 | 1TP1 | TP3666
14 | 1000 | BH-05 | 1TP1 | TP3666
15 | 1000 | BH-05 | 1TP1 | TP3666
16 | 1250 | BH-06 | 1TP4 | TP3669
17 | 1250 | BH-06 | 1TP4 | TP3669
18 | 1250 | BH-06 | 1TP4 | TP3669
Spreadsheet: 62829d1263836345-is-this-type-of-copy-even-possible-test4-1-
Sheet: BSV

Sub | SOP Name | Identifier | Responsible | Due Date | Authored | Approved | Submitted
DATA71 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA72 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA73 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA74 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA75 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA76 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA77 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA78 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA79 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA80 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA81 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA83 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA84 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA85 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA86 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA87 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA89 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA90 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA92 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA93 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA94 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA95 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA96 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA97 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA98 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA99 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA100 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA101 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA102 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA103 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA104 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA105 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
Spreadsheet: 741236d1626929093-calculating-tenure-based-on-start-date-and-end-date-calculating-tenure-based-on-start-date-and-end-date
Sheet: Chart

 |  |  | Fiscal Year 21 | Fiscal Year 21 | Fiscal Year 21 | Fiscal Year 21 | Fiscal Year 21
Tenure | Start Month | End Month | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00
<30 days | 0 | 1
30-90 days |  | 3
90-120 days |  | 4
120-180 days |  | 6
6 mo - 1 yr |  | 12
1-2yr |  | 24
2-5yr |  | 60
5+ yrs
 |  | Total
https://www.excelforum.com/excel-formulas-and-functions/1354981-calculating-tenure-based-on-start-date-and-end-date.html
Spreadsheet: kate_symes__18621__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-26 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-25 00:00:00 |  | 264 | 18800 | 197.99 | 8440
 | 2001-01-24 00:00:00 |  | 272.42 | 7920 | 181.28 | 4440
 | 2001-01-23 00:00:00 |  | 281.71 | 13600 | 186.9 | 3680
 | 2001-01-22 00:00:00 |  | 320.08 | 14960 | 201.71 | 5240
 | 2001-01-21 00:00:00 |  |  |  |  |  | 235 | 29400
 | 2001-01-20 00:00:00 |  | 506.48 | 4320 | 236.31 | 8400
 | 2001-01-19 00:00:00 |  | 505.66 | 4384 | 247.42 | 5032
 | 2001-01-18 00:00:00 |  | 429.29 | 7920 | 278.82 | 6440
 | 2001-01-17 00:00:00 |  | 252.4 | 8000 | 204.13 | 4600
 | 2001-01-16 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
 | 2001-01-15 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
 | 2001-01-14 00:00:00 |  |  |  |  |  | 151.53 | 9000
 | 2001-01-13 00:00:00 |  | 171.82 | 18176 | 152.53 | 3400