tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 056d3091-5b37-480e-836e-e0eb145941d6
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 23. Output of the Rental, hiring and real estate services industries, subdivision, group and class index numbers
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
Index Numbers ;  66 Rental and hiring services (except real estate) ; |  |  | Original | A2314172R | 1996-06-01 00:00:00 | 2013-03-01 00:00:00 | 68 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  661 Motor vehicle and transport equipment rental and hiring ; |  |  | Original | A3343910T | 2001-09-01 00:00:00 | 2013-03-01 00:00:00 | 47 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6611 Passenger car rental and hiring ; |  |  | Original | A3343912W | 2001-09-01 00:00:00 | 2013-03-01 00:00:00 | 47 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6619 Other motor vehicle and transport equipment rental and hiriing ; |  |  | Original | A3343914A | 2001-09-01 00:00:00 | 2013-03-01 00:00:00 | 47 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  663 Other goods and equipment rental and hiring ; |  |  | Original | A2314181T | 1996-06-01 00:00:00 | 2013-03-01 00:00:00 | 68 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6712 Non-residential property operators ; |  |  | Original | A2314163L | 1996-03-01 00:00:00 | 2013-03-01 00:00:00 | 69 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  672 Real estate services ; |  |  | Original | A2314166V | 1998-09-01 00:00:00 | 2013-03-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 174317d1345019869-vlookup-with-drop-down-functionality-vlookup-with-a-drop-down-menu
Sheet: Result

PRODUCTS | 2011 MARCH YEAR TO DATE |  | 2012 FEBRUARY YEAR TO DATE
 | Actual Units | ActualValue | Plan Units | Plan Value | Actual Units | Actual Value
Product A | 60 | 1124 | 30 | 900 | 140 | 1335
Product B
Product C
Product D
1,  Need to put a drop down menu that will give me monthly year to date figures eg- February YTD, March YTD. Which will automatically update figures
2, To do a V LookUP
Spreadsheet: benjamin_rogers__1175__Bernsteins's LM6000 Model
Sheet: PROJECTCONFIGURATION

False | PROJECT CONFIGURATION AT
 |  | QTY |  | EACH |  | ADJ. |  | TOTAL |  | $/KW
 | TURBINE |  |  |  |  | 0
 |  | UNION ? |  | EACH |  | ADJ. |  | TOTAL |  | $/KW
 | BOP |  |  |  |  | 0
 |  | [NAME] |  | SIZE (IN.) |  | ADJ. |  | TOTAL |  | $/KW
 | PIPELINE |  |  |  |  | 0
 |  | YES |  | KV |  | ADJ. |  | TOTAL |  | $/KW
 | POWER INTERCONNECTION |  |  |  |  | 0
 |  | YES |  | EACH |  | ADJ. |  | TOTAL |  | $/KW
 | SCR |  |  |  |  | 0
 |  | YES |  | EACH |  | ADJ. |  | TOTAL |  | $/KW
 | DUAL FUEL |  |  |  |  | 0
 |  | YES |  |  |  | ADJ. |  | TOTAL |  | $/KW
 | BLACK START |  |  | FOR 1 TURBINE |  | 0
 |  | YES |  | AVAILABLE PSIG |  | ADJ. |  | TOTAL |  | $/KW
 | GAS COMPRESSION to 700 PSI |  |  | 600
 |  |  |  | YES |  | ADJ. |  | TOTAL |  | $/KW
 | DEMINERALIZED WATER FACILITY (need 75gpm/turbine) |  |  |  |  | 0
 |  |  |  | YES |  |  |  | TOTAL |  | $/KW
 | CHILLERS |  |  |  |  | 0
 |  |  |  | YES |  | ADJ. |  | TOTAL |  | $/KW
 | SPARE PARTS |  |  |  |  | 0
 | TOTAL ENGINEERING, PROCUREMENT AND CONSTRUCTION |  |  |  |  |  |  | $000 |  | $/KW
 |  | PIPELINE |  | KV |  | UNION ? | DUAL FUEL | BLACK START | COMPRESSION | DEMIN | SPARE | CHILLERS
 | QTY TURBINES | [NAME] | SIZE | INTERCONNECT | SCR |  |  |  |  |  | PARTS
 | 6 | 0 | 16 | 230 | True | False | False | False | False | False | False | True
 |  |  |  | False | True
 | 0 | 0 | 0 | 0
 | 1 | 1 | 4 | 69
 | 2 | 2 | 10 | 138
 | 3 | 3 | 16 | 230
 | 4 | 4 | 24 | 345
 | 5 | 5 |  | 500
 | 6 | 6 |  | 745
 | 7 | 7
 | 8 | 8
 | 9 | 9
 | 10 | 10
Spreadsheet: 719539d1613720802-logic-updates-to-existing-formulas-duplicates-exclusion-lookups-samplep
Sheet: SHIP

ID |  |  | type | rec count |  | [NAME] |  | [NAME] |  |  | Counts |  |  |  |  | Counts:
1163603 |  |  | Final | 302404597 |  | Net Down |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value:302,404,597
1163603 |  |  | Final | 302404597 |  | Net Down |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value:302,404,597
1172600 |  |  | A | 0 |  | Post 100% |  | A |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | INT | 35360098 |  | Post 100% |  | C D w/o I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | Final | 50039 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | Final | 50039 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1179778 |  |  | Final | 11431902 |  | Post 100% |  | C D w/ I |  | Final Reject Sample |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> "Rej" is found in Column K for this ID | Expected Value: 11431902
1179778 |  |  | Final | 393559 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> "Rej" is found in Column K for this ID | Expected Value: 11431902
1224113 |  |  | Final | 21429 |  | Post 100% |  | C D w/ I |  | Final
1226191 | BB of B |  | Final | 90076559 |  | Net Down |  | C D w/ I |  | Final
1226191 | BB of B |  | Final |  |  | Net Down |  | Rp |  | Final
1226572 | AAA |  | INT | 33882484 |  | Post 100% |  | C D w/o I |  | Final
1226572 | AAA |  | Final | 249975 |  | Post 100% |  | C D w/ I |  | Final
Spreadsheet: 678221d1589787152-dynamic-reporting-possible-pivot-table-with-multiple-columns-on-one-sheet-to-source-from-pivottest
Sheet: Data

Client | Agency name | Organisation Type | Progress | Agency name | Organisation Type | Progress | Agency name | Organisation Type | Progress
1 | ONETAKE | GOVERNMENT | STARTUP | GIVEONE | PRIVATE | FINISHED | OUTTERONE | CORPORATION | STARTUP
2 | ONETAKE | GOVERNMENT | ONGOING | GIVETWO | PRIVATE | FINISHED | OUTTERTWO | CORPORATION | STARTUP
3 | TWOTAKE | GOVERNMENT | STALLED | GIVEONE | PRIVATE | STARTUP | GIVETWO | PRIVATE | STARTUP
4 | TWOTAKE | GOVERNMENT | ONGOING | GIVETWO | PRIVATE | STALLED | GIVEONE | PRIVATE | STARTUP
5 | GIVEONE | PRIVATE | STARTUP | ONETAKE | GOVERNMENT | ONGOING
6 | GIVEONE | PRIVATE | STALLED | TWOTAKE | GOVERNMENT | ONGOING
7 | GIVETWO | PRIVATE | FINISHED
8 | GIVETWO | PRIVATE | STALLED
9 | OUTTERONE | CORPORATION | ONGOING
10 | OUTTERONE | CORPORATION | STALLED
11 | OUTTERTWO | CORPORATION | STARTUP
12 | OUTTERTWO | CORPORATION | STARTUP
13
14
15
16
17
18
19
Spreadsheet: 106303d1303480376-data-lookup-or-anything-goes-rail-assembly
Sheet: Sheet1

 |  |  |  |  |  | (1)3" ,(2)6" ,
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | (1)3" , |  |  | (2)6" ,
 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
2 | 1 | 0 | 0 | 1 | 0 | 2 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
3 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 2 | 0 | 1 | 0 | 0 | 1 | 0
5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 2 | 1 | 1 | 2 | 2 | 2 | 3 | 2 | 3
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | (1)3" ,(3)4" ,
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | (1)3" , | (3)4" ,
 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
2 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0
3 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
4 | 0 | 0 | 1 | 0 | 1 | 1 | 2 | 1 | 2 | 2 | 3 | 2 | 3 | 3 | 4 | 3 | 4 | 4 | 5
5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 765111d1643176137-extracting-negative-numbers-from-a-text-cell-with-at-the-end-examples
Sheet: Sheet1

DAIRY FARM SHOP 6.75
WWW.JOHNLEWIS.COM 03456 049 049 25.00
SF CONNECT GBR 3.00
UNION MART LTD SOUTHAMPTON LND 4.08
PAYPAL EB GBR 4.50
Frog Bikes Ltd GBR 1.00
WWW.JOHNLEWIS.COM 03456 049 049 28.00 -
HM.COM [PHONE] 24.96
MARKS&SPENCER PLC INTERNET GBR 20.00 -
MARKS&SPENCER PLC INTERNET GBR 38.00 -
WAITROSE 23.33
NEXT DIRECTORY ONLINE GBR 22.00 -
Spreadsheet: 130486d1322357918-excel-2007-worksheet-command-buttons-to-tabulate-value-questions-and-points2
Sheet: Sheet1

Question |  | answer | Points |  |  |  |  |  |  | What color do you like?
What color do you like? |  | red | 1 |  |  |  |  |  |  | blue | 5
 |  |  |  |  |  |  |  |  |  | green | 3
 |  |  |  |  |  |  |  |  |  | red | 1
 |  |  |  |  |  |  |  |  |  | white | 0
 |  |  |  |  |  |  | Score
1) What color do you like?
 |  |  |  |  |  |  | 5
2) What time is it now?(point to watch)
 |  |  | same | same | same |  | 3
10)
Total |  |  |  |  |  |  | 8
Spreadsheet: 76161d1276705335-putting-cells-within-a-picture-analysis-of-football
Sheet: ROBER

 | DRIBBILE |  |  |  |  | BAD DRIBBLE |  |  |  | PERCENTAGE SUCCESS RATE
 | 0 |  |  |  |  | 0 |  |  |  | #N/A
 | 0 | 0 |  |  |  | 0 | 0 |  |  | #N/A | #N/A
 | 0 | 0 |  |  |  | 0 | 0 |  |  | #N/A | #N/A
 | 0 |  |  |  |  | 0 |  |  |  | #N/A
 | PASS |  |  |  |  | BAD PASS |  |  |  | PERCENTAGE SUCCESS RATE
 | 0 |  |  |  |  | 0 |  |  |  | #N/A
 | 0 | 0 |  |  |  | 0 | 0 |  |  | #N/A | #N/A
 | 0 | 0 |  |  |  | 0 | 0 |  |  | #N/A | #N/A
 | 0 |  |  |  |  | 0 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | PERCENTAGE SUCCESS RATE
 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | PERCENTAGE SUCCESS RATE
 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 781190d1653052023-count-unique-text-by-month-book2
Sheet: Sheet1

ID | Date | W/C | Month |  | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
0022JZ72F | 2022-03-24 00:00:00
0022JZ72F | 2022-03-24 00:00:00
003GQ9Z2D | 2021-08-12 00:00:00
003GQ9Z2D | 2021-08-13 00:00:00
003GQ9Z2D | 2021-08-13 00:00:00
005L1VR6N | 2022-03-19 00:00:00
005L1VR6N | 2022-03-19 00:00:00
005L1VR6N | 2022-03-19 00:00:00
0062VRR0B | 2021-10-26 00:00:00
0062VRR0B | 2021-10-27 00:00:00
0062VRR0B | 2021-10-27 00:00:00
00LBX9H8S | 2022-01-09 00:00:00
00LBX9H8S | 2022-01-10 00:00:00
00LBX9H8S | 2022-01-10 00:00:00
00M80GLL9 | 2021-09-28 00:00:00
00M80GLL9 | 2021-09-28 00:00:00
00M80GLL9 | 2021-09-28 00:00:00
010H63QTQ | 2021-09-15 00:00:00
010H63QTQ | 2021-09-15 00:00:00
015659LCR | 2022-01-24 00:00:00
015659LCR | 2022-01-24 00:00:00
015659LCR | 2022-01-24 00:00:00
01Q5J536S | 2022-04-19 00:00:00
01Q5J536S | 2022-04-19 00:00:00
01Q5J536S | 2022-04-19 00:00:00
01R0Z52CR | 2022-05-06 00:00:00
01R0Z52CR | 2022-05-06 00:00:00
01R0Z52CR | 2022-05-07 00:00:00
01R0Z52CR | 2022-05-07 00:00:00
01VMPK3JR | 2021-07-03 00:00:00
01VMPK3JR | 2021-07-03 00:00:00
024MFXK0Q | 2022-03-24 00:00:00
024MFXK0Q | 2022-03-24 00:00:00
025ZNK8JJ | 2021-12-30 00:00:00
025ZNK8JJ | 2021-12-30 00:00:00
025ZNK8JJ | 2021-12-30 00:00:00
02P8X8XX4 | 2022-01-02 00:00:00
02P8X8XX4 | 2022-01-02 00:00:00
02P8X8XX4 | 2022-01-03 00:00:00
02RC3PRG1 | 2022-02-04 00:00:00
02RC3PRG1 | 2022-02-04 00:00:00
02RC3PRG1 | 2022-02-04 00:00:00
03F70RBW4 | 2021-04-25 00:00:00
03F70RBW4 | 2021-04-26 00:00:00
03KG3TM9T | 2022-03-27 00:00:00
03KG3TM9T | 2022-03-27 00:00:00
03KG3TM9T | 2022-03-27 00:00:00
03N8FB3MQ | 2021-09-28 00:00:00
03N8FB3MQ | 2021-09-29 00:00:00
Spreadsheet: benjamin_rogers__1192__test model from Erin
Sheet: CSHFLO-ENA

Cash Flow
Project Revenues:
Project Operating Expenses:
Fuel Charges
O&M Expenses
Working Capital Changes
Return of Maintenance Reserve
Operating Cash Flow
Debt Service:
Interest Payments
Principal Payments
LC Charge on DSRF
Interest Income
Total Debt Service
Federal Income Taxes
NET A-T CASH FLOW
Debt Service Coverage Ratios
Debt Life
Long Term Debt
Interest
Principal
Long Term Debt Service
TOTAL DEBT SERVICE
DSC Ratios:
Long Term DSCR
Average
Minimum
Average Life
Total Debt Coverage Ratio
 |  | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 10.5 | 11.5 | 12.5 | 13.5 | 14.5 | 15.5 | 16.5 | 17.5 | 18.5 | 19.5
Spreadsheet: 5635ee18-7533-433f-8753-c050bb6f3613
Sheet: Sheet1

PARTIAL LISTING OF SOME INFO FROM COMP GUIDE:  (Ch 2, 4, 5)      updated February 2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | NC Water Quality Standards |  |  |  | Typical Detection Levels |  |  |  |  | Literature | Literature |  | 40 CFR | 40 CFR | 40 CFR
 | For Freshwater Classes |  |  |  | See your LTMP/STMP |  |  | Literature | Literature | Anaerobic | Median |  | 503 | 503 | 503
 | Class C | Class WS |  |  | for your own |  |  | Uncon- | AS / Nit | Digester | AS |  | [NAME] | [NAME] | Composte
 | Aquatic | Water | Trout |  | Division approved |  |  | -trollable | Inhibition | Inhibition | Removal |  | Cumulative | Ceiling | Ceiling
 | Life | Supply | Waters |  | detection levels |  |  | Values | Values | Values | Rates |  | Standard | Standard | Standard
Parameters | mg/l | mg/l | mg/l |  | ug/l | mg/l |  | mg/l | mg/l | mg/l | % |  | lbs/acre | mg/kg | mg/kg
Arsenic | 0.05 | 0.01 |  |  | 10 | 0.01 |  | 0.003 | 0.10 / 1.50 | 1.6 | 0.45 |  | 36 | 75 | 41
Cadmium | 0.002 |  | 0.0004 |  | 2 | 0.002 |  | 0.003 | 1.00 / 5.20 | 20 | 0.67 |  | 34 | 85 | 39
Chloride | 230 *AL | 250 |  |  | 1000 | 1 |  | 50
Chromium, total | 0.05 |  |  |  | 5 | 0.005 |  | 0.05 | 1.00 / 0.394 | 130 | 0.82
Copper, total | 0.007 *AL |  |  |  | 2 | 0.002 |  | 0.061 | 1.00 / 0.48 | 40 | 0.86 |  | 1338 | 4300 | 1500
Cyanide | 0.005 |  |  |  | 10 | 0.01 |  | 0.015 | 0.10 / 0.34 | 4 | 0.69
Lead | 0.025 |  |  |  | 10 | 0.01 |  | 0.049 | 1.0 / 0.50 | 340 | 0.61 |  | 267 | 840 | 300
Mercury | 0.000012 mg/l                                           0.012 ug/l;                       12 ng/l |  |  |  | 0.2 ug/l using EPA 245.1 /         0.001 ug/l using EPA 1631 | 200 ng/l using    EPA 245.1 /   1 ng/l using EPA 1631 |  | 0.0003 | 0.10 /  n/a |  | 0.6 |  | 15 | 57 | 17
Molybdenum |  |  |  |  | 100 | 0.1 |  |  |  |  | 0.33 |  |  | 75 | 75
Nickel | 0.088 | 0.025 |  |  | 10 | 0.01 |  | 0.021 | 1.00 / 0.25 | 10 | 0.42 |  | 374 | 420 | 420
Selenium | 0.005 |  |  |  | 10 | 0.01 |  |  |  |  | 0.5 |  | 89 | 100 | 100
Silver | 0.00006 *AL |  |  |  | 5 | 0.005 |  | 0.005 | 0.25 /  n/a | 13 | 0.75
Sulfates |  | 250 |  |  | 1000 | 1 |  | 30
Zinc | 0.05 *AL |  |  |  | 10 | 0.01 |  | 0.175 | 1.0 / 1.0 | 400 | 0.79 |  | 2498 | 7500 | 2800
BOD |  |  |  |  | 2000 | 2 |  | 220 |  |  | Site specific
TSS |  |  |  |  | 2000 | 2 |  | 220 |  |  | Site Specific
Ammonia |  |  |  |  | 100 | 0.1 |  | 25 | 480 / n/a | 1500 | Site specific
Phosphorus, T |  |  |  |  | 500 | 0.5 |  | 8 |  |  | Site specific
Nitrogen, Total |  |  |  |  | 1000 | 1 |  | 40 |  |  | Site specific
Oil & Grease |  |  |  |  | 5000 | 5 |  | 100 |  |  | Site specific
AL* = Action Level |  |  |  |  |  |  |  |  | AS=Activated Sludge; Nit.=Nitrification
Spreadsheet: 588325d1535560209-creating-categories-based-on-order-of-test-completion-samplework
Sheet: Working

ID | Date | Test
1 | August 20, 2018 at 10:49 AM (MDT) | Math
1 | August 24, 2018 at 01:03 PM (MDT) | English
1 | August 24, 2018 at 12:41 PM (MDT) | Science
2 | August 20, 2018 at 10:49 AM (MDT) | Math
2 | August 24, 2018 at 01:03 PM (MDT) | Science
2 | August 24, 2018 at 12:41 PM (MDT) | English
Spreadsheet: 172932d1344371605-too-many-if-statements-causing-my-excel-workbook-to-be-too-large-and-slow-test-new-revenue-summary
Sheet: Rev Summ

 |  |  |  |  |  |  | 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total | Subtotal
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2012 | 2013 | by Division | Client | Buying | Planning | Split 50/50 | Split 50/50
Client | Flight Start | Flight End
Pepsi | 2012-04-02 00:00:00 | 2012-04-08 00:00:00 | 1000 | 1000 | 1000 | 2580 |  |  |  |  |  |  |  |  |  |  |  | RF | RF | CP
Coke | 2011-08-26 00:00:00 | 2012-08-25 00:00:00 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 |  |  |  | Sanderfield | Sanderfield | Sanderfield
Mountain Dew | 2011-10-28 00:00:00 | 2012-10-26 00:00:00 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 |  |  |  |  |  | Griego | Griego | Griego
Dr Pepper | 2011-12-09 00:00:00 | 2012-12-08 00:00:00 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 |  |  |  |  | Griego | Griego | Griego
Sprite | 2011-11-11 00:00:00 | 2012-11-10 00:00:00 | 5000 | 5000 | 5000 | 5000 |  |  |  |  |  |  |  |  |  |  |  | JU | JU | JU
[NAME] | 2011-11-18 00:00:00 | 2012-06-08 00:00:00 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 1328.6 | 385.7 |  |  |  |  |  |  |  |  |  |  | MB | CP
Diet Pepsi | 2012-02-03 00:00:00 | 2012-04-12 00:00:00 |  |  | 896 | 1680 | 1344 |  |  |  |  |  |  |  |  |  |  | Block | Block | Block
Pepsi | 2011-12-02 00:00:00 | 2012-04-19 00:00:00 | 3321.4 | 3107.2 | 3321.4 | 2104.97 |  |  |  |  |  |  |  |  |  |  |  | Block | Block | Block
Coke | 2012-01-06 00:00:00 | 2012-04-27 00:00:00 | 2500 |  | 2500 |  | 2500 |  | 2500 |  | 2500 |  | 2500 |  |  |  |  | BP | BP | CS
Mountain Dew | 2011-12-16 00:00:00 | 2012-01-13 00:00:00 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rivera | Rivera | Rivera
Dr Pepper | 2011-12-16 00:00:00 | 2012-01-13 00:00:00 | 10000 | 10000 | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CS | CP
Sprite | 2011-12-30 00:00:00 | 2012-12-28 00:00:00 | 2258.6 | 2112.8 | 2258.6 | 2185.7 | 2258.6 | 2185.7 | 2258.6 | 655.7 |  |  |  |  |  |  |  | Merritt | Ejelonu | Ejelonu
Spreadsheet: 270669d1381580238-sumif-advanced-30-daysforum
Sheet: Cashflow

Cash Flow |  |  | 2013-09-12 00:00:00
 | Outgoing | Total Unpaid | 30+ Days |  | Incoming | Total Unpaid | 30+ Days
 | Suppliers |  |  |  | Unpaid invoices
 | Overheads |  |  |  | Still to be invoiced
 | Wages
 | Wages - Tax&NI
 | Subcontractors
 | Subcontractors CIS
 | VAT
Spreadsheet: 704731d1605720055-nested-if-function-only-show-data-when-available-q_if
Sheet: Sheet1

 |  |  |  |  |  |  |  | VOG-Eloy gr.1/2B |  |  | VOG-Eloy gr.3 |  |  | VOG-Eloy gr.4 |  |  | VOG-Eloy gr.6
 |  |  |  |  | Date | CO2 |  | Date | CO2 |  | Date | CO2 |  | Date | CO2 |  | Date | CO2
VOG-Eloy |  |  |  |  |  |  |  | 2020-11-09 00:00:00 | 779 |  | 2020-11-09 00:00:00 | 1648 |  | 2020-11-09 00:00:00 | 674 |  | 2020-11-09 00:00:00 | 1527
VOG-Eloy gr.6 |  | VOG-Eloy gr.1/2B |  |  |  |  |  |  | 915 |  |  | 807 |  |  | 1927 |  |  | 1624
 |  | VOG-Eloy gr.3 |  |  |  |  |  |  | 1604 |  |  | 1158 |  |  | 626 |  |  | 1900
 |  | VOG-Eloy gr.4 |  |  |  |  |  |  | 860 |  |  | 1874 |  |  | 1484 |  |  | 606
 |  | VOG-Eloy gr.6 |  |  |  |  |  |  | 954 |  |  | 794 |  |  | 1559 |  |  | 852
 |  |  |  |  |  |  |  |  | 1824 |  |  | 922 |  |  | 715 |  |  | 604
 |  |  |  |  |  |  |  |  | 986 |  |  | 1031 |  |  | 781 |  |  | 1457
 |  |  |  |  |  |  |  |  | 1815 |  |  | 1085 |  |  | 1296 |  |  | 1597
 |  |  |  |  |  |  |  |  | 1481 |  |  | 1646 |  |  | 1733 |  |  | 1617
 |  |  |  |  |  |  |  |  | 1534 |  |  | 907 |  |  | 1237 |  |  | 1773
 |  |  |  |  |  |  |  |  | 1968 |  |  | 1557 |  |  | 1190 |  |  | 1842
 |  |  |  |  |  |  |  |  | 947 |  |  | 1177 |  |  | 1844
 |  |  |  |  |  |  |  |  | 947
 |  |  |  |  |  |  |  |  | 947
 |  |  |  |  |  |  |  |  | 947
Spreadsheet: 218022d1362304354-referencing-cells-from-a-master-sheet-master-schedule-test-nhopkins-oeldere-
Sheet: pivot table

 | Kolomlabels
 | Som van total 1 |  |  | Som van total 2 |  |  | Eindtotaal Som van total 1 | Eindtotaal Som van total 2
Rijlabels | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00
Allysa Kelly | 9.25 | 9.25 |  | 18.5 | 18.5 |  | 18.5 | 37
Gregory Mills | 0 |  |  | 0 |  |  | 0 | 0
[NAME] |  |  | 4.625 |  |  | 2.3125 | 4.625 | 2.3125
[NAME] |  |  | 4.625 |  |  | 2.3125 | 4.625 | 2.3125
Tyler Rowe | 0 |  |  | 0 |  |  | 0 | 0
Vida Handrak | 0 | 4.625 |  | 0 | 2.3125 |  | 4.625 | 2.3125
(leeg) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Eindtotaal | 9.25 | 13.875 | 9.25 | 18.5 | 20.8125 | 4.625 | 32.375 | 43.9375
Spreadsheet: 0101f86c-8e79-419c-bdfe-3e124db78809
Sheet: Sheet1

Results
Updated: XX/XX/XX
PLACE | Last Name | First Name | Total Points | Race #1 | Race #2 | Race #3 | Race #4 | Race #5 | Race #6 | Race #7
 |  |  |  | [NAME] | HITS | Sand Hollow | State Games | Jordanelle | Eagle in the Sun | Littlefoot
 |  |  |  | Albuquerque, NM | Grand Junction, CO | St. George, UT | [NAME], CO | Park City, UT | El Paso, TX | Lakewood, CO
YOUTH MALE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
YOUTH FEMALE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Junior Male
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
JUNIOR FEMALE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 790258d1659614427-filtering-students-based-on-conditions-and-construct-a-table-another-case
Sheet: P1

Excemption Students
Stage | Student Name | Semester | Excempt Subject | Mark
Third | student name 1 | First | subject 1 | 50
Third | student name 1 | First | subject 4 | 67
Third | student name 1 | First | subject 5 | 77
Third | student name 1 | First | subject 6 | 51
Third | student name 1 | First | subject 14 | 55
Third | student name 1 | Second | subject 1 | 65
Third | student name 1 | Second | subject 2 | 87
Third | student name 1 | Second | subject 5 | 66
Third | student name 1 | First | subject 2 | 55
Third | Student name 2 | First | subject 2 | 52
Third | Student name 2 | First | subject 4 | 61
Third | Student name 2 | First | subject 6 | 77
Third | Student name 2 | Second | subject 1 | 50
Third | Student name 2 | Second | subject 4 | 67
Third | Student name 2 | Second | subject 5 | 77
Third | Student name 2 | Second | subject 6 | 51
Third | Student name 2 | First | subject 1 | 68
Third | Student name 2 | First | subject 12 | 60
Third | Student name 3 | Second | subject 3 | 59