tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0267bf81-567d-41a5-893a-cc409cdb4ca2
Sheet: Sheet1

 | This is a Preliminary spreadsheet listing standards that Military Friendly institutions are accomplishing.  It is based on research of military friendly institutions across the United States, and the American Council on Education's report titled, "From Soldier to Student: Easing the Transition of Service Members on Campus." (2009) (Updated 2012)
 | What Military Friendly Colleges are Doing |  | What FHSU is doing |  | Future Goals for FHSU | Goals attained
 | School has a lot of current military students |  | X
 | Availability of Financial Aid |  | X
 | Number of military contracts |  | X
 | Accredited online degree programs |  | X
 | Located in close proximity to military bases
 | Offer courses directly on military bases |  |  |  | X
 | *Offer special scholarships |  |  |  | X
 | *Offer special financial aid to spouses |  | X
 | Accepts credit for occupational specialties MOS |  | X
 | *Accepts ACE credits (AARTS, SMART, CCAF, or CGI) |  | X
 | Web pages specific to military personnel |  | X
 | Clear distinction that military person is not just another student |  | X
 | Member of SOC |  | X
 | *Low tuition rates |  | X
 | Assisting Service Members with their transition to college |  | X
 | Prof. devel. for [NAME] and Staff regarding transitional needs of soldiers |  | X
 | Faculty and Staff Training for special needs of soldiers (PTSD) |  | X
 | *No hidden course fees |  | X
 | Tuition rates clearly defined on web pages |  | X
 | Clear and direct answers to questions |  | X
 | Doesn't make the student commit to long term agreement |  | X
 | *Extend discounts to spouses
 | Clearly defined degree map (no unnecessary courses) |  | X
 | A history of experience with military |  | X
 | Lenient policy for military withdrawals due to deployment |  | X
 | Streamlined campus procedures for soldiers returning from deployment |  | X
 | Military spouses get to take their first class free
 | Military spouse discounts of 20% or more
 | *Numerous online degrees to choose from |  | X
 | Supportive staff |  | X
 | Provide resources for soldiers to connect with peers |  |  |  | X
 | Advisors who are responsive and quick to answer questions |  | X
 | Up-to-date website |  | X
 | Waiving the application fee
 | Programs that bridge military careers with careers outside the military |  |  |  | X
 | Processes for CLEP and DANTES credits |  | X
 | Quick answers on transferability of credits
 | *Accepts TA and GI Bill |  | X
 | On-campus location for Military (lounge, work room, etc) |  | X
 | *  Most Common Characteristics
Spreadsheet: 126075d1319509593-showing-ratio-percentage-on-an-excel-chart-bs-1-it-lab-
Sheet: Sheet3

Products | Sales |  | Sales (in 1000) 2010 | Projections (in 1000) 2011
Whoopie cushions | 35000 | 35 | 35 | 17.5
[NAME] | 27000 | 27 | 27 | 13.5
Invisible Ink Pens | 30000 | 30 | 27 | 13.5
Fake Noses | 15000 | 15 | 15 | 7.5
[NAME] | 14000 | 14 | 14 | 7
Squrting Flowers | 25000 | 25 | 25 | 12.5
Spreadsheet: 738008d1624742569-enter-y-if-calculation-greater-than-x-bo-trend-backtesting
Sheet: RESULTS

 | GAIN/LOSS |  |  |  | LEGEND |  | WEEKLY
 |  |  |  |  |  |  | WEEK | TRADES | WIN % | < .50 | G/L | 2 PTS | @ HIGH
 | Win/Loss % |  |  |  |  |  | 25 | 19 | 0.5263157894736842 | 4 | 10.14 |  | 39.81
 | Trading Days |  |  |  |  |  | 24 | 14 |  | 3 | 12.87 |  | 27.33
 | Trades |  |  |  |  |  | 23 | 11 |  | 4 | 8.01 |  | 89.88
 | Wins |  |  |  |  |  | 22 | 5 |  | 2 | 2.17 |  | 11.42
 | Gain /s (Total) |  |  |  | Total points per share |  | 21
 | Gain /s (Ave) |  |  |  | Ave points per share per trade |  | 20
 |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | 18
 | SETUP % |  |  |  |  |  | 17
 |  | Trades | Traded % | Wins % |  |  | 16
 | PM Consolidation |  |  |  |  |  | 15
 | Consolidation |  |  |  |  |  | 14
 | PMH |  |  |  |  |  | 13
 | Pivot |  |  |  |  |  | 12
 | HOD |  |  |  |  |  | 11
 | POP |  |  |  |  |  | 10
 | HIGHS % |  |  |  | LEGEND
 | Entry-High Ave |  |  |  | Percentage High above Entry
 | High-Close Ave |  |  |  | Percentage High above Close
 | ENTRY TIMES (WINNING TRADES)
 |  | Trades | Traded % | Ave Entry
 | 4:00-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-14:59
Spreadsheet: 783423d1654796153-summarize-and-total-data-from-another-sheet-2022-06-09-oeldere-lichldo-sample-excel
Sheet: Pivot Table

criteria | yes
Rijlabels | Som van Hours
PDF Phase | 43
- Account Director | 4
- Creative Artworker | 8
- Creative Director - Concepts | 2
- Creative Mid - Design & Amends | 8
- Creative Senior -Art Direction | 12
- Production Manager | 1
- Project Manager Senior | 8
Video Phase | 88
- Account Director | 7
- Copywriting | 16
- Creative Artworker | 12
- Creative Director - Concepts | 2
- Creative Mid - Design & Amends | 16
- Creative Senior -Art Direction | 20
- Production Manager | 2
- Project Manager Senior | 13
Webpage Phase | 21.5
- Account Director | 4
- Copywriter Senior | 4
- Creative Artworker | 4
- Creative Director - Concepts | 2
- Creative Mid - Design & Amends
- Creative Senior -Art Direction
- Group Account Director
- Project Manager Senior | 7.5
Eindtotaal | 152.5
Spreadsheet: 139614d1328337304-excel-2010-bi-weekly-paycheck-tracker-income-calculator
Sheet: Jun 2012

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Made with [NAME]: | Calendar Maker
 | ◄ May |  |  |  | ~ June 2012 ~ |  |  |  |  |  |  |  | July ► |  |  |  |  |  |  |  |  |  |  |  | 2011 Calendar
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  |  |  |  |  |  |  |  |  | 2012 Calendar
 |  |  |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00 |  | 2012-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2012-06-03 00:00:00 |  | 2012-06-04 00:00:00 |  | 2012-06-05 00:00:00 |  | 2012-06-06 00:00:00 |  | 2012-06-07 00:00:00 |  | 2012-06-08 00:00:00 |  | 2012-06-09 00:00:00
 | 2012-06-10 00:00:00 |  | 2012-06-11 00:00:00 |  | 2012-06-12 00:00:00 |  | 2012-06-13 00:00:00 |  | 2012-06-14 00:00:00 |  | 2012-06-15 00:00:00 |  | 2012-06-16 00:00:00
 | 2012-06-17 00:00:00 |  | 2012-06-18 00:00:00 |  | 2012-06-19 00:00:00 |  | 2012-06-20 00:00:00 |  | 2012-06-21 00:00:00 |  | 2012-06-22 00:00:00 |  | 2012-06-23 00:00:00
 | 2012-06-24 00:00:00 |  | 2012-06-25 00:00:00 |  | 2012-06-26 00:00:00 |  | 2012-06-27 00:00:00 |  | 2012-06-28 00:00:00 |  | 2012-06-29 00:00:00 |  | 2012-06-30 00:00:00
Spreadsheet: 474072d1470614023-trying-to-sum-count-from-multiple-worksheets-sampleforecasting-2
Sheet: J

Toshiba
Account Code | Customer Name | Sales Rep | Part Number | Description |  |  |  |  |  | Comments
 |  |  |  |  | August | September | October | November | December
MBI001 | example: MBIE | PCH | PT251A-00C002 | Toshiba Portege Z30-B, Intel Core i5-5300U 2.3/2.7GHz, 13.3" Widescreen HD Backlit Display (1366x768), 4GB DDR3L 1600Mhz memory (one slot used, one slot free) to to 16GB (service technician required), 128GB mSATA SSD, Intel Graphics Media Accelerator, 1Gbps LAN + AM10.0, Intel a/g/n  Bluetooth, [NAME], 4 Cell [NAME], Microsoft Windows 7 Pro 64Bit, with Microsoft Windows 8.1 Pro 64Bit Pro Media in the Box, 3 year warranty | 15 | 15 | 20 |  |  | For building move
 | Customer 33 | JAB |  |  | 1 | 2 | 3
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
 |  | JAB
Spreadsheet: 65118d1265847665-vlookup-with-potential-for-multiple-matches-mail-test
Sheet: Team E

emp | id
 | LYH4
 | LMGJ
 | MQS0
 | LRQF
 | LG71
 | MTYP
 | L84T
 | MB4Y
 | L5PR
 | [NAME]
 | L6XD
 | DSWW
 | LG4Q
 | LMGH
 | MB4X
 | LNPH
 | LDXH
 | MSXN
 | MMM6
 | MR4F
 | MT70
 | MNMK
 | LDXL
 | L5LQ
 | HJ8Z
 | LD0F
 | LS68
 | MGFL
 | [NAME]
Spreadsheet: 790119d1659540062-lookup-a-value-in-tab-and-insert-corresponding-data-into-new-tabs-resource-db-excelforum-separate-tab
Sheet: Sales

 | Name | Surname | [NAME] |  |  |  | Sales
1 |  | surname42 | email42
2 | name50 | surname50 | [NAME]
3 | name96 | surname96 | [NAME]
4 | name140 | surname140 | email140
5
6
7
etc…
Spreadsheet: 871077d1717514683-slicers-not-linking-pivots-from-two-different-data-sets-slicers-not-linking-to-pivots-from-different-data-sets
Sheet: SUMMARY

 |  |  |  |  | [NAME] | All
 |  |  |  |  | Invoiced
 |  | Budget |  |  |  | Jan | Feb | Mar | Apr | Grand Total
 | HB9352 | 36989 |  |  | HB9352 | 2120 | 1130 | 3840 | 2270 | 9360
 | PO16448 | 28151 |  |  | PO16448 | 2700 | 2730 | 680 | 730 | 6840
 | RI27772 | 28470 |  |  | RI27772 | 2140 | 1170 | 540 | 1370 | 5220
 | UU6204 | 29813 |  |  | UU6204 | 2420 | 1830 | 2020 | 1270 | 7540
 | Grand Total | 123423 |  |  | Grand Total | 9380 | 6860 | 7080 | 5640 | 28960
Spreadsheet: 01f95e58-8d04-4b9c-ae27-83714e154693
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | FORMULARIO C
ORGANIZACIÓN DE AVIACIÓN CIVIL INTERNACIONAL
FORMULARIO DE INFORMACIÓN DE TRANSPORTE AÉREO
TRÁFICO POR ETAPAS (TFS)
Servicios regulares (de pago) - Operaciones internacionales
Persona contacto: |  |  |  |  |  | Estado:
Organización: |  |  |  |  |  | Línea aérea:
[NAME]:
Facsímile: |  |  |  |  |  | [NAME]:
Correo-e:
Estaciones |  |  |  | Capacidad disponible |  | Tráfico de pago
 |  |  |  |  | Capacidad
 |  |  |  | Asientos | total para
 |  |  |  | de pasajeros | carga de pago | Pasajeros | Mercancías | Correo
Desde | Hasta | Tipo de aeronave | [NAME] | (número) | (toneladas) | (número) | (toneladas) | (toneladas)
a | b | c | d | e | f | g | h | i
Observaciones (menciónese también toda desviación inevitable respecto de las instrucciones):
[NAME] utilizarse hojas adicionales.
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 29 March 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-03-29 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS | Annual leave
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | Com off Air Show
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Annual leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS | Annual leave
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
[NAME] Leaves
1.     Wednesday 14th March 2012: Comp off
2.     Thursday 15th March 2012: Comp off
3.     Friday 16th March 2012: Comp Off
4.     Saturday 17th March 2012: Comp off
5.     Sunday 18th March 2012 : 2011 annual leave pending
6.     Monday 19th March 2012 : 2011 annual leave pending
7.     Tuesday 20th March 2012 : 2011 annual leave pending
8.     Wednesday 21stMarch 2012 : 2011 annual leave pending
9.     Thursday22ndMarch 2012 : report to duty
10.                        Friday: 23rd March 2012: 2011 annual leave pending
11.                        Sunday 25 March 2012: 2011 annual leave pending
12.                        Monday 26March 2012 : 2011 annual leave pending
13.                        Tuesday 27March 2012 : 2011 annual leave pending
14.                        Wednesday 28March 2012 : 2011 annual leave pending
15.                        Thursday 29 March 2012 : 2011 annual leave pending
16.                        Friday
17.                        Saturday
18.                        Sunday 1st April : reporting back
Spreadsheet: 28434d1222711178-moving-weighted-average-formula-weighting1
Sheet: Sheet1

6
6 |  |  | 1
2 | 4 |  | 2
3 | 4.555555555555555 |  | 3
6 | 5.888888888888889 |  | 2
10 | 6.555555555555555 |  | 1
7 | 6.111111111111111
0 | 4.666666666666667
8 | 5
2 | 4.777777777777778
10 | 4.888888888888889
1 | 2.777777777777778
0 | 2.111111111111111
0 | 1.777777777777778
7 | 3.666666666666667
1 | 4.333333333333333
10 | 5.555555555555555
2 | 4.777777777777778
7 | 4.555555555555555
2 | 3.666666666666667
2 | 3.666666666666667
7 | 3.555555555555555
2 | 3.222222222222222
1 | 3.666666666666667
5 | 4.777777777777778
9 | 6.222222222222222
6 | 6.555555555555555
6
6
Spreadsheet: 719659d1613750862-summing-a-column-due-to-an-if-function-example-for-forum
Sheet: Accounting

 | Accounting
 |  | Cost | Sell |  |  | Cost | Sell
 | General Materials |  |  |  | Material |  |  |  | Mats
 | Labour |  |  |  | Labour |  |  |  | Lab
 | Plant
 | Sub-Contractor |  |  |  | TOTAL
 | Sustenance etc
 | Modules
 | [NAME]
 | TOTAL |  |  |  | xRET:
Spreadsheet: 879585d1727172943-matching-email-addresses-from-another-sheet-in-multiple-columns-and-returning-main-address-fweja-emails-trying-to-find-spill-365-aligw
Sheet: All active staff

Main Email Address | Alias1 | Alias2 | Alias3 | Alias4 | Alias5 | Alias6 | Alias7 | Alias8 | Alias9 | Alias10
[EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
[EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Spreadsheet: 876487d1723184208-iferror-help-blank-training-tracker_2024
Sheet: Training Log

 | TRAINING LOG
 | NAME | PERSONNEL STATUS | COURSE | FREQUENCY | TRAINING DATE | EXPIRATION DATE | RETRAINING DATE | STATUS
 | [NAME] |  |  |  | 2024-01-02 00:00:00
Spreadsheet: 793182d1661350528-creating-a-results-list-of-multiple-races-finn-resultaten-2022
Sheet: 31 juli

 |  | Place | 1e wedstrijd | 2e wedstrijd | 3e wedstrijd |  |  | Place | sailnumber | points | points overall | count
 |  | 1 | 148 | 148 | 148 |  |  | 1 |  | 3 | 9
 |  | 2 | 85 | 113 | 151 |  |  | 2 | 151 | 10 | 8
 |  | 3 | 222 | 222 | 13 |  |  | 3 | 222 | 10 | 7
 |  | 4 | 151 | 151 | 222 |  |  | 4 | 113 | 14 | 6
 |  | 5 | 13 | 19 | 19 |  |  | 5 | 13 | 16 | 5
 |  | 6 | 113 | 85 | 113 |  |  | 6 | 85 | 16 | 4
 |  | 7 | 145 | 145 | 145 |  |  | 7 | 19 | 19 | 3
 |  | 8 | 47 | 13 | 85 |  |  | 8 | 145 | 21 | 2
 |  | 9 | 19 | 47 | 47 |  |  | 9 | 47 | 26 | 1
 |  |  |  |  |  |  |  |  | #REF! | #REF!
Spreadsheet: 2b9352f4-458e-4eef-9df6-3e7f15fe5328
Sheet: Sheet1

Grant Application Detailed Budget | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | U.S. Department of Housing and Urban Development | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | OMB Approval No. 2501-0017 (exp. 11/30/2014) | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  | Functional Categories                     [Year 1:__] [Year 2:__] [Year 3:__] [All Years:__]
Name of Project/Activity: |  |  |  |  | Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9
 |  |  |  |  | HUD Share | Applicant   Match | Other HUD Funds | Other Fed Share | State Share | Local/Tribal Share | Other | Program Income | Total
a.  Personnel (Direct Labor) |  |  |  |  | $ | $ | $ | $ | $ | $ | $ | $ | $
b.  [NAME]
c.  Travel
d.  Equipment (only items > $5,000 depreciated value)
e.  Supplies (only items w/depreciated Value < $5,000 )
f.  Contractual
g.  Construction
 | 1. Administration and legal expenses
 | 2. Land, structures, rights-of way, appraisals, etc.
 | 3. Relocation expenses and payments
 | 4. Architectural and engineering fees
 | 5. Other architectural and engineering fees
 | 6. Project inspection fees
 | 7. Site work
 | 8. Demolition and removal
 | 9. Construction
 | 10. Equipment
 | 11. Contingencies
 | 12. Miscellaneous
h. Other (Direct Costs)
i.  Subtotal of Direct Costs
j.  Indirect Costs (% Approved Indirect Cost Rate:___%)
Grand Total (Year:___):
Grand Total (All Years):
Spreadsheet: 390227d1429555425-sumif-while-finding-a-sum_range-sumif-example
Sheet: SUN

Date Range: 04/05/2015 - 04/05/2015 |  | Financial Detail |  |  |  | Location/Terminal : Corporation - ALL
Time Range: 00:00 - 24:00
Location | Terminal | Adjusted Plu |  | Cancel |  | Cash Sales |  | Cash-in-d |  | Chg1 Drawer |  | Chg8 Drawer |  | Chg8 Sales |  | Credit |  | Drwr Ttl |  | Error Correction |  | Grand Ttl |  | Gross Sales |  | Net Sale |  | Non Tax |  | P/o 1 |  | Positive Plu |  | Tax1 Sales |  | Tax1 Total
 |  | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount | Count | Amount
MNS - 205 | MNS #205 ECR1 | 1574 | 3617.6 | 13 | 81.39 | 569 | 2328.07 | 569 | 2328.07 | 239 | 1266.04 | 11 | 54.64 | 11 | 54.64 | 239 | 1266.04 | 819 | 3648.75 | 15 | -36.93 | 818 | 3648.75 | 0 | 3648.75 | 818 | 3648.75 | 1477 | 3118.51 | 0 | 0 | 1574 | 3617.6 | 0 | 499.09 | 0 | 31.15
MNS - 211 | MNS #211 ECR2 | 334 | 1097.6 | 0 | 0 | 153 | 637.46 | 154 | 5.49 | 64 | 487.52 | 0 | 0 | 0 | 0 | 64 | 487.52 | 218 | 493.01 | 0 | 0 | 217 | 1124.98 | 0 | 1124.98 | 217 | 1124.98 | 278 | 659.83 | 1 | -631.97 | 334 | 1097.6 | 0 | 437.77 | 0 | 27.38
Spreadsheet: cf4f6897-7a59-4b8c-8e2f-f9be51b5b4de
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | ANNEX I
 | [NAME]: |  |  |  |  |  | NIF:
 | Data de la Resolució: |  |  | Import ajuda concedida: |  |  | Import altres ajudes:
 | LLISTA ENUMERATIVA DE LES DESPESES DERIVADES DE L'EXPEDIENT |  |  |  |  |  | DE
N. | Núm. Fra. | Data Fra.  (DD/MM/AAAA) | Proveïdor | Concepte | Total base imposable | IVA | TOTAL | Data  pagament (DD/MM/AAAA) | Forma Pagament | Cost Imputable (sense IVA) *
Aquesta relació correspon [NAME] cost total definitiu del projecte subvencionable, els justificants del qual s'adjunten. |  |  |  |  | * Import de la factura que s'imputa al projecte subvencionat. En el cas que sigui la totalitat de la factura es repeteix [NAME] imposable.
 | Data:
 | [NAME]:
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-5

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-16 00:00:00
 |  |  | Monitoring Well #: | MW-5 |  |  |  | Well Depth: | 11.77 |  | ft |  |  | Screened/Open Interval: | 4-12' |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 8.25 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 2.78 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 815 | x |  | 6.47 | NA | 20.05 | NA | 2074 | NA | 0.83 | NA | -32.5 | NA | 43.1 | NA | 400 | 4.11
 | 820 | x |  | 6.46 |  | 20.25 |  | 2060 |  | 0.67 |  | -35.9 |  | 44.5 |  | 400 | 4.45
 | 825 | x |  | 6.45 |  | 20.47 |  | 2035 |  | 0.4 |  | -37.9 |  | 32.3 |  | 400 | 5.19
 | 830 | x |  | 6.44 |  | 20.5 |  | 2030 |  | 0.41 |  | -38.1 |  | 16.5 |  | 400 | 5.28
 | 835 | x |  | 6.44 |  | 20.6 |  | 2028 |  | 0.41 |  | -36.9 |  | 15.9 |  | 400 | 5.31
 | 840 | x |  | 6.45 |  | 20.62 |  | 2028 |  | 0.4 |  | -35.9 |  | 15.2 |  | 400 | 5.38
 | 845 |  | x | 6.44 |  | 20.72 |  | 2030 |  | 0.41 |  | -34.5 |  | 12.1 |  | 400 | 5.46
 | Comments:
 |  | Purge start: |  |  | 08:13:00 |  |  | Sample time: |  | 08:42:00
 |  | Purge end: |  |  | 08:40:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 813151d1673584514-cost-allocation-schedule-once-trigger-engaged-sample-cost-allocation-bvj-
Sheet: Sheet1

 |  | Challenge: | I want the cost of the project to begin allocating the project cost ($1m) in the month the project starts (March 2023).
 |  | Project cost: | 1000000
 |  | start date: | 2023-03-01 00:00:00
 |  | Month | Cost Allocation |  |  |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
 |  | 1 | 0.02
 |  | 2 | 0.05
 |  | 3 | 0.05
 |  | 4 | 0.08 |  |  | Desired result
 |  | 5 | 0.12 |  |  | [NAME]'s
 |  | 6 | 0.165
 |  | 7 | 0.165
 |  | 8 | 0.12 |  |  | AllocationTable | =Sheet1!$D$8:$D$19
 |  | 9 | 0.08 |  |  | ProjCost | =Sheet1!$D$5
 |  | 10 | 0.05 |  |  | ProjStart | =Sheet1!$D$6
 |  | 11 | 0.05
 |  | 12 | 0.05