tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4772539c-103b-4d64-a8f3-0fc8f587807b
Sheet: Sheet1

Supplemental Table 8. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
CG Number | [NAME] | fru P1/M | Biological Process | Molecular Function
CG3746 | CG3746 | 3.791889322
CG2177* | CG2177 | 3.316972083 | ion transport (2.2E-2) | metal ion transporter activity
CG10717* | Ecdysone-inducible gene L1 | 2.903526778
CG11710 | CG11710 | 2.90031833 | regulation of cellular metabolism | transcription cofactor activity
CG11893* | CG11893 | 2.717423488
CG10537 | Resistant to dieldrin | 2.424660235 | ion transport (2.2E-2) | GABA receptor activity
CG7755 | CG7755 | 2.163171864 |  | oxidoreductase acting on CH-OH donors
CG9438* | Cytochrome P450-6a2 | 2.121598215 | response to insecticide (3.1E-2) | monooxygenase activity
CG11426 | CG11426 | 2.065606609 | lipid metabolism | phosphoric ester hydrolase activity
CG6437 | GlcT-1 | 2.04766465 | regulation of programmed cell death | UDP-glycosyltransferase activity
CG14938 | crooked legs | 1.899946517 | wing disc development | transition metal ion binding
CG7208 | CG7208 | 1.697595797 | lipid metabolism
CG30148 | CG30148 | 1.68290651 | biopolymer metabolism | hydrolase activity on glycosyl bonds
CG9893 | lethal (2) 06496 | 1.627817927 | establishment of localization (3.2E-2)
CG7946 | CG7946 | 1.519048884
CG7813 | CG7813 | 1.487661374 | ion transport (2.2E-2) | hydrolase activity on acid anhydrides
CG5700 | pericardin | 1.401306131 | establishment of localization (3.2E-2)
CG8713* | CG8713 | 0.276109693 | ion transport (2.2E-2) | voltage-gated ion channel activity
CG14329 | CG14329 | 0.354493537
CG8863 | CG8863 | 0.552045189 | response to protein stimulus | heat shock protein binding
CG40115 | CG40115 | 0.574468681
CG4312* | Metallothionein B | 0.586210058 | transition metal ion binding | cell ion homeostasis
CG7638 | CG7638 | 0.661393497
CG15520 | capability | 0.665007934 | ion transport (2.2E-2) | neuropeptide hormone activity
CG11539 | CG11539 | 0.706720888 | imaginal disc morphogenesis | transforming growth factor beta receptor
CG6155 | Roe1 | 0.720230973 | establishment of localization (3.2E-2) | adenyl nucleotide binding
Spreadsheet: 859682d1707986872-lookup-2-column-lookup-2-column
Sheet: Sheet1

Rev/Exp | Sub | Order |  | Pdt | Rev/Exp | Sub | Order
Revenue | Trade | 1 |  | #1 | Revenue | Trade |  | <----What formula should I use to get Column H
Revenue | G&A | 2 |  | #2 | Expenses | Staff Cost |  | * Column H is base on Column A:C and F:G
Revenue | Non-Trade | 3 |  | #3 | Expenses | Trade
Revenue | Dividend Income | 4 |  | #4 | Expenses | Staff Cost
Expenses | Trade | 5 |  | #5 | Expenses | Depreciation
Expenses | Staff Cost | 6 |  | #6 | Revenue | G&A
Expenses | Depreciation | 7 |  | #7 | Expenses | G&A
Expenses | G&A | 8
Expenses | Taxation | 9
Spreadsheet: 605825d1547303741-how-to-use-countif-function-or-any-other-formula-to-sort-year-country-and-any-occurrenc-aijaz75
Sheet: Sheet1

Year | Country |  |  | Year | Country | Occurrence
2000 | Afghanistan |  |  | 2000 | Afghanistan | 2
2000 | Afghanistan |  |  | 2000 | India | 1
2000 | India |  |  | 2000 | Malaysia | 1
2000 | Malaysia |  |  | 2001 | Afghanistan | 2
2001 | Afghanistan |  |  | 2001 | India | 3
2001 | Afghanistan |  |  | Grand Total |  | 9
2001 | India
2001 | India
2001 | India
Spreadsheet: john_lavorato__16525__bonusesaa
Sheet: Sheet2

Associate & Analyst
driscoll, [NAME] |  | analyst | 75000
mallory, [NAME] |  | analyst | 75000
[NAME] bill |  | analyst | 75000
ballato |  | analyst | 25000
ames |  | analyst | 25000
brodeur, stephane |  | analyst | 25000
Watt, [NAME] |  | analyst | 25000
makkai |  | analyst | 18000
wolfe |  | analyst | 18000
chu-yang-heu, mog |  | analyst | 18000
Bayer |  | analyst | 18000
scott, susan |  | analyst | 18000
Saibi, [NAME] |  | analyst | 18000
Lenhart, [NAME] |  | analyst | 18000
Draper, Lon |  | analyst | 18000
Coffing, [NAME] |  | analyst | 12500
Salisbury, Holden |  | analyst | 12500
[NAME], [NAME] |  | analyst | 12500
[NAME], [NAME] |  | analyst | 12500
[NAME], fabian |  | analyst | 12500
Plachy, Denver |  | analyst | 12500
Kaniss, [NAME] |  | analyst | 12500
Falik, Brian |  | analyst | 12500
Jenkins, [NAME] |  | analyst | 12500
[NAME], [NAME] |  | associate | 40000
richey, cooper |  | associate | 40000
Smith, [NAME] |  | associate | 40000
schiavone |  | associate | 40000
[NAME], [NAME] |  | associate | 40000 |  |  |  |  |  |  | OTHER
benchluch |  | associate | 30000 |  | Total
Quigley |  | associate | 30000
richey, cooper |  | associate | 30000
Schneider |  | associate | 30000
[NAME] |  | associate | 30000
Imai, Rika |  | associate | 30000
[NAME] |  | associate | 25000
Stokley, [NAME] |  | associate | 25000
Gualy, Jaime |  | associate | 25000
[NAME], [NAME] |  | associate | 25000
Oh, Seung-Taek |  | associate | 25000
[NAME] |  | associate | 25000
Rogers, [NAME] |  | associate | 25000
giron |  | associate | 15000
rostant |  | associate | 15000
[NAME], Willis |  | associate | 15000
Gay, Randall |  | associate | 15000
Terp, [NAME] |  | associate | 15000
Pimenov, Vladi |  | associate | 15000
Versen |  | associate | 15000
Yawaponshiri, Virawan |  | associate | 15000
Irvin, [NAME] |  | commercial | 50000
woulfe, greg |  | commercial | 150000
Josey, Scott |  | commercial | 150000
Melendrez, [NAME] |  | commercial | 75000
Keel, [NAME] |  | commercial | 75000
[NAME], [NAME] |  | commercial | 175000
Millier, [NAME] |  | commercial | 175000
Mccarroll
Mathews, [NAME]
Cardenas, Catalina
Omalley, Justin
Burk, [NAME]
Schlesinger, Lauren
Hull
Wills, Cory
[NAME], Hi
Lowell, [NAME]
Mahajan, Ashish
Savvas, [NAME]
[NAME], [NAME]
Shupe
Marquez, [NAME]
Maskell, [NAME]
[NAME], [NAME]
Seely, [NAME]
[NAME]
Freije
[NAME], [NAME]
Aggarwal
Shim
Pan
[NAME], Gulay
Ha, Amie
[NAME], [NAME]
[NAME], Dustin
Bajwa, Bilal
Berutti, [NAME]
Pathak, Neeran
[NAME], [NAME]
Rawal, Punit
[NAME]
[NAME], [NAME]
Spreadsheet: 98763d1297624953-vlookup-issue-appts-lookup-sample
Sheet: lookup data set

recordid | act_code | Scheduled Date | result_code
019P91KITX | APPOINT | 2010-08-19 00:00:00 | SHOWNOSALE | 1-019P91KITX
019P91KITX | APPOINT | 2010-08-17 00:00:00 | CANCEL | 2-019P91KITX
01OC5EMITX | APPOINT | 2010-10-21 00:00:00 | CANCEL | 1-01OC5EMITX
01OC5EMITX | APPOINT | 2010-07-20 00:00:00 | SHOWNOSALE | 2-01OC5EMITX
000HBDVITX | APPOINT | 2010-11-13 00:00:00 | NOSHOW | 1-000HBDVITX
001L2X8ITX | APPOINT | 2010-08-28 00:00:00 | NOSHOW | 1-001L2X8ITX
00LU0UQITX | APPOINT | 2010-12-04 00:00:00 | NOSHOW | 1-00LU0UQITX
00LU0UQITX | APPOINT | 2010-11-23 00:00:00 | CTREXCPTN | 2-00LU0UQITX
00LU0UQITX | APPOINT | 2010-11-20 00:00:00 | NOSHOW | 3-00LU0UQITX
Spreadsheet: 21194d1208386799-any-excel-to-pdf-pros-out-there-latest-2008-10622
Sheet: Page 1

Report of Inspection, Testing & Maintenance
of Wet Pipe Fire Sprinkler Systems
ALL QUESTIONS ARE TO BE ANSWERED AND ALL BLANKS FILLED
(Weekly inspection tasks are NOT included in this report)
 | Inspecting Firm: Fire Prevention Services Ltd. Sprinkler Division |  |  |  |  |  |  | W.O.# |  | [NAME]
 | Name of Inspected Property: Kitikmeot Boarding House    5116-522st   Yellowknife NT
 | Inspector Name: [NAME] |  |  |  |  |  |  | Date: |  | 2008-01-25 00:00:00
 | Inspection Frequency:
 | Monthly Inspection for Wet Pipe Sprinkler System
 |  |  |  |  |  |  |  |  |  | Y | N/A | N
 | [NAME] in service on inspection |  |  |  |  |  |  |  |  | x
 | A.2.0 Supply pressure gauge | Initial Observation |  |  |  |  |  |  |  |  |  | PSI
 | A.2.1 [NAME] pressure gauge | Initial Observation |  |  |  |  |  |  |  |  |  | PSI
 | A.2.2 Gauges appear to be in good condition |  |  |  |  |  |  |  |  | x
 | A.3.0 Control valves in normal open or closed position |  |  |  |  |  |  |  |  | x
 | A.3.1 Control valves properly locked or supervised |  |  |  |  |  |  |  |  | x
 | A.3.2 Control valves accessible |  |  |  |  |  |  |  |  | x
 | A.3.3 Control valves provided with appropriate wrenches |  |  |  |  |  |  |  |  |  | x
 | A.3.4 Control valves free from external leaks |  |  |  |  |  |  |  |  | x
 | A.3.5 Control valve identification signs in place |  |  |  |  |  |  |  |  |  |  | x
 | A.3.6 Zone control valve sign(s) indicate area served |  |  |  |  |  |  |  |  |  |  | x
 | A.4.0 Backflow prevention assembly valves are locked or electrically supervised in open position |  |  |  |  |  |  |  |  | x
 | [NAME] pressure backflow prevention assembly not in continuous discharge |  |  |  |  |  |  |  |  |  | x
 | A.5.0 [NAME] valve gauges indicate normal supply water pressure |  |  |  |  |  |  |  |  |  | x
 | A.5.1 Alarm valve free of physical damage |  |  |  |  |  |  |  |  |  | x
 | [NAME] valve trim valves are in appropriate open or closed position |  |  |  |  |  |  |  |  |  | x
 | A.5.3 Alarm valve retarding chamber or alarm drain not leaking |  |  |  |  |  |  |  |  |  | x
 | A.6.0 ALARM PANEL CLEAR |  |  |  |  |  |  |  |  | x
 | A.7.0 COMMENTS:
 | (Form 106A)
 | INSPECTOR'S INITIAL ________          OWNER/DESIGNATED REP.INITIAL ________         DATE: ________                        Page 1 of 4
Spreadsheet: c521533e-a82f-40d4-9211-af69ca34dd9b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40830319 | 2014-04-04 00:48:53 | AXIS | 0 | 5 | 7 | 1515794 | Bodega28 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40887249 | 2014-04-07 17:56:50 | AXIS | 0 | 4 | 5 | 1167400 | Chenille | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
40887434 | 2014-04-07 18:15:22 | ALLIES | 0 | 4 | 5 | 1167400 | Chenille | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
40918252 | 2014-04-09 20:52:51 | AXIS | 0 | 2 | 5 | 1249072 | player1249072 | 9597 | western | 1944-06-06 | 1944-06-06 | Utah Beach | Utah Beach
40954292 | 2014-04-12 13:15:34 | AXIS | 1 | 10 | 7 | 946197 | Groka | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40977964 | 2014-04-13 22:50:54 | AXIS | 0 | 4 | 6 | 637960 | kurivial | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
40978111 | 2014-04-13 23:06:18 | ALLIES | 0 | 5 | 6 | 637960 | kurivial | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
40978322 | 2014-04-13 23:30:00 | AXIS | 0 | 5 | 6 | 971161 | mschoenh | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
41001124 | 2014-04-15 14:35:50 | AXIS | 1 | 5 | 0 | 1449105 | p-h-hildenbrand | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
Spreadsheet: 5cb35206-d057-4c7f-9c98-1406eeb1fe0d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-03-05 09:40:53.040000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.354 | 102.229 | 102.104 | 101.729
4.5 | 101.414 | 101.289 | 101.164 | 100.789 |  | Note: | Refer To Price [NAME]
4.375 | 100.424 | 100.299 | 100.174 | 99.799 |  |  | For all Price Adjs
4.25 | 99.791 | 99.666 | 99.541 | 98.916
4.125 | 98.95 | 98.825 | 98.7 | 98.075
4 | 97.92 | 97.795 | 97.67 | 97.045
3.875 | 96.856 | 96.731 | 96.606 | 95.981
3.75 | 95.981 | 95.856 | 95.731 | 95.106
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.448 | 102.323 | 102.198 | 101.823
3.75 | 102.382 | 102.257 | 102.132 | 101.757
3.625 | 101.981 | 101.856 | 101.731 | 101.356
3.5 | 101.405 | 101.28 | 101.155 | 100.53
3.375 | 100.654 | 100.529 | 100.404 | 99.779
3.25 | 99.865 | 99.74 | 99.615 | 98.99 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-03-19 09:40:53.040000
30 DAY | 2014-04-03 09:40:53.040000
45 DAY | 2014-04-18 09:40:53.040000
60 DAY | 2014-05-03 09:40:53.040000
90 DAY | 2014-06-02 09:40:53.040000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 00e6a559-d336-41c0-8265-e20a5df3e2f5
Sheet: Tab 3 - Economic Impact

TAB 3. ECONOMIC IMPACT
Data: |  |  |  |  |  |  | Estimated within 1-year after project completion
A. | NEW Jobs:
 | 1. | NEW permanent direct jobs from positions being CREATED, or vacant ones being filled.
 |  | a. | Full-time jobs
 |  | b. | Part-time jobs - For scoring purposes, 2.5 part-time jobs are considered a Full Time Equivalent (FTE).  OB will calculate FTEs.
 | 2. | "NEW" permanent direct jobs TRANSFERRED TO PA FROM OUT OF STATE.  "NEW" for this entry's purpose only includes existing, filled positions that will be transferred into PA from out of state.
 |  | a. | Full-time jobs
 |  | b. | Part-time jobs - For scoring purposes, 2.5 part-time jobs are considered an FTE.  OB will calculate FTEs.
B. | RETAINED permanent direct (non-construction) jobs.  "RETAINED" for this purpose includes existing jobs, currently located elsewhere in PA or existing jobs retained at a current employment site that will be lost without the progression of this project.
 | 1. | Full-time jobs
 | 2. | Part-time jobs - For scoring purposes, 2.5 part-time jobs are considered an FTE.  OB will calculate FTEs.
C. | Number of permanent INDIRECT jobs created by support/supplier industries and secondary industries attracted by the project.  Must supply multiplier basis used by the project.
D. | Number of non-permanent direct (CONSTRUCTION) jobs created by the project.
E. | MEDIAN ANNUAL WAGE for all NEW permanent direct full-time jobs.
F. | Provide the PER CAPITA INCOME for the project's county per the U. S. Census Bureau at the following link:
 | [NAME]
G. | Total STATE TAX GENERATION (payroll, sales, corporate, etc.). |  |  |  |  | Prior to project
Spreadsheet: 840437d1692732157-find-top-3-delays-from-production-data-top-3-delays-from-a-production-table-excelforum
Sheet: Sheet1

 | Item | Measure | 2023-08-15 00:00:00 | 2023-08-16 00:00:00 | 2023-08-17 00:00:00 | 2023-08-18 00:00:00 | 2023-08-19 00:00:00 | 2023-08-20 00:00:00 | 2023-08-21 00:00:00 | 2023-08-22 00:00:00 | Total to date |  | Top 3 Delayed Items as of | 2023-08-19 00:00:00
 | Mango | Target | 10 | 10 | 20 | 30 | 10 | 5 | 5 | 10
 | Mango | Actual | 5 | 10 | 10 | 5 | 20 |  |  |  |  |  | [NAME]
 | Apple | Target | 30 | 10 | 5 | 5 | 20 | 5 | 10 | 5 |  |  | Apple
 | Apple | Actual | 10 | 5 | 10 | 5 | 5
 | [NAME] | Target | 20 | 20 | 40 | 5 | 5 | 5 | 5 | 5
 | [NAME] | Actual | 10 | 10 | 15 | 5 | 5
 | Carrot | Target | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 | Carrot | Actual | 5 | 5 | 5 | 5 | 5
 | Cabbage | Target | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | Cabbage | Actual | 10 | 10 | 10 | 10 | 10
Spreadsheet: 861822d1709651239-integer-number-formula-integer-number-formula-ans
Sheet: Formula Needed

 |  |  | RP1 | RP2 | RP3 | RP4 | RP5 | RP6 | RP7 | RP8 | RP9 | RP10 | RP11 | RP12 | RP13 | RP14
Percentage can be changed but total will be always 100% |  |  | 0.5 | 0.6 | 0.46 | 0 | 0.71 | 0.9 | 0 | 0 | 1 | 0.71 | 0.46 | 0.48 | 0.6 | 0.44
 |  |  | 0.5 | 0 | 0.07 | 0 | 0.29 | 0.1 | 0 | 0.41 | 0 | 0.29 | 0.37 | 0.46 | 0 | 0.42
 |  |  | 0 | 0.4 | 0.47 | 1 | 0 | 0 | 1 | 0.59 | 0 | 0 | 0.17 | 0.06 | 0.4 | 0.14
Ex.1 Select 6 Num |  | 6
 |  | Sum
For example In C11, I pick 6 numbers that I want to distribute accordingly D6:Q8 %, in the D11:Q13 as [NAME] I cannot get total 6 in row 14
Ex.1 Select 10 Num |  | 10
 |  | Sum
For example In C19, I pick 10 numbers that I want to distribute accordingly D6:Q8 %, in the [NAME]:Q22 as Integer Numbers I cannot get total 10 in row 22
 |  | I need a formula that distribute exact amount of picked numbers in the range also varying the % it should match the total of numbers between selected & picked.
Spreadsheet: af77ea36-eb85-479c-a5e7-39f305623bcd
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
 | 6202.0 Labour Force, Australia
 | Table 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2013-07-01 00:00:00 | 421 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 818246d1676664378-expanding-a-formula-school-closures-new-formula
Sheet: Sheet1

DATE | AES |  |  | ALO |  |  | AQS |  |  | ARN |  |  | ATT |  |  | IGH |  |  | IHS |  |  | INU |  |  | JOA |  |  | NAK |  |  | NAN |  |  | NAS |  |  | NUI |  |  | PAA |  |  | PPS |  |  | QAQ |  |  | QAR |  |  | QIK |  |  | QUL |  |  | SMS |  |  | SPS |  |  | ULA |  |  | UMI
 | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES | REASON | FULL/HALF | NOTES
 | OR | 1 |  | or | 1 |  | or | 1
 | OR | 1 |  | or | 2 |  | or | 4
 | CGS | 1.5
 | CGS | 1.5
 | WEATHER | 2
 | WEATHER | 2
 | FUNERAL | 2.5
 | FUNERAL | 2.5
Spreadsheet: craig_dean__4357__11-29act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 882012d1730272168-transform-data-from-one-sheet-to-other-book2-1-
Sheet: Sheet1

Column1 | Column2 | Salesman-01 | Salesman-03 | [NAME] | Salesman-07 | Salesman-08 | Salesman-12 | Salesman-17 | Salesman-20 | Salesman-21 | Salesman-25
Product 1 | Area 1 | 4 | 5 | 4 | 2 | 1 | 2 | 3 | 4 | 3 | 4
Product 1 | Area 2 | 1 | 0 | 5 | 5 | 3 | 0 | 5 | 5 | 3 | 3
Product 1 | Area 3 | 4 | 5 | 3 | 2 | 5 | 1 | 3 | 2 | 1 | 3
Product 1 | Area 4 | 3 | 3 | 4 | 1 | 0 | 5 | 4 | 4 | 0 | 3
Product 1 | Area 5 | 2 | 5 | 2 | 5 | 2 | 1 | 1 | 5 | 3 | 3
Product 2 | Area 1 | 5 | 1 | 0 | 1 | 1 | 1 | 2 | 1 | 2 | 1
Product 2 | Area 2 | 3 | 2 | 2 | 3 | 2 | 2 | 4 | 5 | 2 | 3
Product 2 | Area 3 | 2 | 0 | 2 | 5 | 2 | 4 | 4 | 1 | 0 | 3
Product 2 | Area 4 | 2 | 3 | 0 | 3 | 3 | 0 | 5 | 3 | 4 | 1
Product 2 | Area 5 | 1 | 1 | 1 | 1 | 5 | 3 | 1 | 1 | 0 | 3
Product 2 | Area 6 | 4 | 4 | 3 | 0 | 2 | 4 | 0 | 0 | 2 | 3
Product 2 | Area 7 | 2 | 4 | 4 | 3 | 4 | 2 | 4 | 5 | 1 | 1
Product 2 | Area 8 | 4 | 1 | 0 | 4 | 5 | 5 | 5 | 0 | 2 | 0
Product 2 | Area 9 | 0 | 1 | 5 | 2 | 2 | 1 | 0 | 1 | 0 | 4
Product 2 | Area 10 | 4 | 3 | 3 | 4 | 0 | 5 | 0 | 4 | 2 | 4
Product 2 | Area 11 | 4 | 0 | 0 | 5 | 5 | 0 | 3 | 1 | 4 | 3
Product 2 | Area 12 | 3 | 5 | 4 | 5 | 4 | 4 | 3 | 5 | 0 | 1
Product 2 | Area 13 | 1 | 3 | 4 | 5 | 2 | 4 | 5 | 5 | 4 | 5
Spreadsheet: 568363d1522591184-lookup-multiple-occurrences-of-the-same-value-in-two-different-columns-ef1136g_with-the-hyphen
Sheet: ELO

Name | ELO 1 | ELO 2 | ELO 3 | ELO 4 | ELO 5 | ELO 6 | ELO 7 | ELO 8 | ELO 9 | ELO 10 | ELO 11 | ELO 12 | ELO 13 | ELO 14 | ELO 15 | Num_games | Latest_ELO | Rank_ELO |  | Current_ranking |  |  |  | G_1 | G_2 | G_3 | G_4 | G_5 | G_6 | G_7 | G_8 | G_9 | G_10 | G_11 | G_12 | G_13 | G_14 | Combined
Adam |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Alicia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Amy-Alice |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Braxton |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Ellie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Erin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Grace |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Jessica |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
Olivia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
[NAME]
[NAME]
[NAME]
Tyron