tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg15

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Practice Range A |  | Field Name: |  | Practice Range B |  | Field Name: |  | Drip Zone 1 (S) |  | Field Name: |  | Drip Zone 2 (S)
 |  |  |  |  |  | Area (acres): |  | 8 |  | Area (acres): |  | 7.06 |  | Area (acres): |  | 18.8 |  | Area (acres): |  | 19.19
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 83.2 |  | Annual Rate (in): |  | 41.6 |  | Annual Rate (in): |  | 78.2 |  | Annual Rate (in): |  | 78.2
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 40732d1239130521-sumproduct-question-piechartmappingexample
Sheet: Data Sheet

Profit Center | GL Account | Account Description | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Previous Year
2010 | 400600 | COGS - PACKAGING | -638.59 | -851.72 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010 | 500500 | PPV OUTSIDE SERVICES | -2528 | -376.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010 | 500600 | PPV PACKAGING | 1969.53 | 4036.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010 | 500800 | O/S FREIGHT | 2957.63 | 3072.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 764375d1642702367-countifs-with-than-symbol-on-dates-ehpraracker
Sheet: Tracker

 | Status |  |  |  | To review | In progress | Moved to QP | Closed | Total
 | To review |  |  | <19/01/2022
 | In Progress |  |  | 2022-01-19 00:00:00
 | Transferred to QP |  |  | 2022-01-20 00:00:00
 | Closed |  |  | 2022-01-21 00:00:00
 | TOTAL tickets |  |  | 2022-01-24 00:00:00
 |  |  |  | 2022-01-25 00:00:00
 |  |  |  | 2022-01-26 00:00:00
 |  |  |  | 2022-01-27 00:00:00
 |  |  |  | 2022-01-28 00:00:00
 |  |  |  | 2022-01-31 00:00:00
Spreadsheet: 1d14715a-a91a-4a10-9503-fee0f03d4df3
Sheet: Table 1.4

Monthly Statistical Bulletin
1.4 Long-term unemployment
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Long-term unemployed (a) (b) – '000
July | 100.0527005 | 111.0348818 | 112.6471868 | 112.4712895 | 137.6302151
August | 98.31056 | 107.0234813 | 126.3308991 | 120.475792 | 134.4010317
September | 98.6631691 | 117.0848995 | 111.3130216 | 122.5585266 | 133.409451
October | 100.3482962 | 127.8643723 | 114.3943082 | 117.6733065 | 145.3443853
November | 106.9010722 | 116.0151358 | 109.3706716 | 130.3612346 | 145.6214536
December | 112.880546 | 110.2780924 | 107.9895572 | 118.2159606 | 152.3034043
January | 107.9184373 | 107.3548132 | 126.2372264 | 119.8888299 | 149.244978
February | 109.1260692 | 111.8581177 | 113.3456595 | 115.6906084 | 153.1654377
March | 106.7812483 | 116.8804156 | 115.8245024 | 120.7245563 | 163.8244435
April | 113.8871244 | 112.2242939 | 119.8706641 | 116.4425655 | 159.6459503
May | 111.4677792 | 119.7747354 | 112.476476 | 127.7220502
June | 112.7394573 | 113.2402878 | 114.575806 | 136.6783615
Annual average | 106.7938189583333 | 113.919219425 | 115.2809436916667 | 121.5399985416667
Percentage of total unemployed (b) – per cent
July | 15.33877118072535 | 17.9462635845018 | 18.59409359968473 | 17.97389707527878 | 19.87108495326946
August | 14.97643510510496 | 18.28399437558072 | 20.33082154947449 | 19.67328768690409 | 19.09810017962847
September | 15.1406894412616 | 19.72983158863163 | 17.86583992388755 | 18.48734365267569 | 19.21711040334043
October | 15.5882145187535 | 20.72327181422197 | 18.72670897629451 | 18.21464066905694 | 20.69608816321087
November | 16.73618627369224 | 19.30339284286595 | 17.59372027963219 | 20.64143189357735 | 20.63108906083809
December | 17.81512965594289 | 19.26283855008649 | 17.59002184267633 | 18.13946408084803 | 21.3174003832433
January | 17.70969278055164 | 18.07558526421523 | 20.87547135010616 | 18.23674689823315 | 20.4504044745228
February | 17.84557641516315 | 19.08649118878047 | 18.31570126041262 | 17.65400481786504 | 20.65724818991244
March | 17.13038717944623 | 20.24768154467957 | 18.83843742238555 | 17.81232349666338 | 22.95137818877989
April | 17.97932732707265 | 19.28647235447715 | 20.17094030915376 | 17.15321182853663 | 22.37768593641272
May | 18.59396950875211 | 20.45980220394224 | 18.20984131341398 | 18.9733176337404
June | 18.84431055256837 | 19.40448889107221 | 18.43207999858524 | 19.57922387761583
Annual average | 17.00185190069184 | 19.28599124195199 | 18.7800546886211 | 18.52233725134591
(a) Unemployed for 52 weeks or more.
(b) Monthly figures are seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6291.0.55.001 |  |  |  |  |  |  |  | 2014-06-19 00:00:00
Spreadsheet: 94804d1294576895-need-help-with-reverse-percentage-lookup-book1_takers
Sheet: Sheet1

Current Value | % Difference from Last Year | Last Year |  | Proof calcs > | % of Last Year | now
100 | -0.3 | 142.8571428571429 |  |  | 0.7 | 100
100 | -0.2 | 125 |  |  | 0.8 | 100
100 | -0.1 | 111.1111111111111 |  |  | 0.9 | 100
100 | 0 | 100 |  |  | 1 | 100
100 | 0.1 | 90.9090909090909 |  |  | 1.1 | 100
100 | 0.2 | 83.33333333333334 |  |  | 1.2 | 100
100 | 0.3 | 76.92307692307692 |  |  | 1.3 | 100
100 | 0.4 | 71.42857142857143 |  |  | 1.4 | 100
100 | 0.5 | 66.66666666666667 |  |  | 1.5 | 100
100 | 0.6 | 62.5 |  |  | 1.6 | 100
100 | 0.7 | 58.82352941176471 |  |  | 1.7 | 100
100 | 0.8 | 55.55555555555556 |  |  | 1.8 | 100
100 | 0.9 | 52.63157894736842 |  |  | 1.9 | 100
100 | 1 | 50 |  |  | 2 | 100
100 | 1.1 | 47.61904761904762 |  |  | 2.1 | 100
100 | 11.2 | 8.196721311475411 |  |  | 12.2 | 100
100 | 21.3 | 4.484304932735426 |  |  | 22.3 | 100
100 | 31.4 | 3.08641975308642 |  |  | 32.4 | 100
100 | 41.5 | 2.352941176470588 |  |  | 42.5 | 100
100 | 51.6 | 1.901140684410646 |  |  | 52.6 | 100
100 | 61.7 | 1.594896331738437 |  |  | 62.7 | 100
100 | 71.8 | 1.373626373626374 |  |  | 72.8 | 100
100 | 81.9 | 1.20627261761158 |  |  | 82.9 | 100
100 | 92 | 1.075268817204301 |  |  | 93 | 100
100 | 102.1 | 0.9699321047526673 |  |  | 103.1 | 100
100 | 112.2 | 0.8833922261484098 |  |  | 113.2 | 100
100 | 122.3 | 0.8110300081103001 |  |  | 123.3 | 100
100 | 132.4 | 0.7496251874062968 |  |  | 133.4 | 100
100 | 142.5 | 0.6968641114982579 |  |  | 143.5 | 100
100 | 152.6 | 0.6510416666666667 |  |  | 153.6 | 100
Spreadsheet: 47746d1246923952-formula-to-automatically-add-values-each-week-nsd3
Sheet: Sheet1

 | 1st 13 Weeks (Wk 24 -Wk 36) |  |  | Wk 24 |  |  | WK 25 |  |  | Wk 26 |  |  | Wk 27 |  |  | WK 28 |  |  | WK 29 |  |  | WK 30 |  |  | WK 31 |  |  | WK 32 |  |  | WK 33 |  |  | WK 34 |  |  | WK 35 |  |  | WK 36
 | TOTAL 13 week target | Target to date | Cumulative Actual Total | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast | Forecast | Actual | % to Forecast
Total Market | 19812.916 | 9906.458 | 40028 | 5560.028 | 840 | 0.1510783758642942 | 2085.066 | 2808 | 1.346719959943714 | 259.032 | 12432 | 47.99407023070509 | 2002.332 | 3934 | 1.964709149132112 | 9906.458 | 20014 | 2.020298274115733 | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A | 0 | 0 | #N/A
Spreadsheet: 026621a4-eb22-464b-8080-8464ae239b7f
Sheet: Sheet1

TYPE OF PROJECT | REQ.#.OF PLANS | BLDG. | PLNG. | PUBLIC  WORKS | FIRE / HAZ MAT | POLICE | REC & PARKS | STORM  WATER | COUNTY HEALTH | Unnamed: 10 | STORM WATER | L.A. COUNTY HEALTH DEPT.
RESIDENTIAL
Single Family Dwellings, Duplex's
New House, Garage or Accessory bldg | 3 | n1 | n | n
Addition to existing building | 3 | n1 | n | n
Remodel to existing building (kitchen, bathrm, solar panls) | 3 | n | n | n3 | n3
Miscellaneous (siding, stucco,window change out, trellis) | 2 | n | n
Site work (driveways, block wall / fence) | 3 | n | n | n
Grading | 3 | n | n | n
Pool/spa | 3 | n | n | n
MULTI-FAMILY 3+ Units ( 1 Structure)
Condo, Apartment, Apt.Prkg Garage, [NAME].
New building or addition to existing building | 7 | n1 | n | n | n | n | n2 | n |  |  | n
Remodel (interior remodel, solar panels) | 3 | n | n | n3 | n3
Misc - Window replacemt, roof, patio enclosure, trellis | 2 | n | n
Site work (walls,pkg lot upgr, landscape/hardcape) | 7 | n | n | n | n | n | n2 | n |  |  | n
Grading | 5 | n | n | n |  |  | n2 | n |  |  | n
Pool/spa (Hlth Dept.Issues Permit) Elec.& Plumb.(City Issues) | 4 | n | n | n |  |  |  |  | n |  |  | n
Signs | 3 | n | n | n
COMMERCIAL / INDUSTRIAL
New building or addition to existing building | 7 | n1 | n | n | n | n | n2 | n | n |  | n
[NAME], Change of Use, Arch/Struc.Changes | 5 | n | n | n | n | n
Change of use / new restaurant | 6 | n | n | n | n | n |  |  |  |  |  | n
Alteration of existing restaurant | 6 | n | n | n | n | n |  |  |  |  |  | n
New restaurant | 7 | n | n | n | n | n |  |  | n |  | n | n
Miscellaneous -roofing, siding, window change out | 2 | n | n
Site work - walls, prkg lots, landscp,hardscape | 5 | n | n | n | n |  | n2
Grading | 6 | n | n | n |  |  | n2 | n |  |  | n
Mechanical Equipment-Struc.[NAME] Req.(rooftop/outside equip) | 3 | n | n |  | n
Signs | 3 | n | n | n
Hazardous materials storage | 4 | n | n | n | n
Parking light standards-Elec. not included | 4 | n | n | n |  | n
Pool/spa (Health Dept.issues Permit -City issues Elec.& Plumb/Mech.) | 4 | n | n | n |  |  |  |  | n |  |  | n
Note 1: Structural Plans and cCalculations are required ONLY for Building &Safety
Note 2: Clearance from Rec and Park required for landscaping plans
Note 3: Only for Solar Panels
Spreadsheet: 104443d1302041511-excel-2007-lookup-table-loop-book1
Sheet: Data

Data | Total Simplex Pages | Total Duplex Pages
SYSNAME=iR8070;CANON_101=101042;CANON_103=25;CANON_201=98454;CANON_203=25;CANON_DEVICENAME=iR8070;
SYSNAME=iR C4080;CANON_101=378164;CANON_102=378167;CANON_109=189582;CANON_DEVICENAME=iR C4080;
SYSNAME=iR-ADV C5051;CANON_101=3191;CANON_108=983;CANON_229=3;CANON_230=605;CANON_321=0;CANON_322=1600;CANON_DEVICENAME=iR-ADV C5051;
SYSNAME=iR3570;CANON_101=58980;CANON_103=2;CANON_201=51631;CANON_203=2;CANON_DEVICENAME=iR3570;
SYSNAME=iR4570;CANON_101=315338;CANON_102=315517;CANON_DEVICENAME=iR4570;
SYSNAME=iR8070;CANON_101=118879;CANON_103=71;CANON_201=118668;CANON_203=71;CANON_DEVICENAME[NAME];
SYSNAME=iR8070;CANON_101=101285;CANON_103=25;CANON_201=98570;CANON_203=25;CANON_DEVICENAME=iR8070;
SYSNAME=iR C4080;CANON_101=380026;CANON_102=380029;CANON_109=190531;CANON_DEVICENAME=iR C4080;
SYSNAME=iR C5185;CANON_101=143660;CANON_108=85549;CANON_102=143755;CANON_109=85594;CANON_321=31;CANON_322=33796;CANON_DEVICENAME=iR C5185;
SYSNAME=iR-ADV C5051;CANON_101=3780;CANON_108=1198;CANON_229=3;CANON_230=610;CANON_321=0;CANON_322=1969;CANON_DEVICENAME=iR-ADV C5051;
SYSNAME=iR4570;CANON_101=316035;CANON_102=316214;CANON_DEVICENAME=iR4570;
SYSNAME=iR3570;CANON_101=59181;CANON_103=2;CANON_201=51778;CANON_203=2;CANON_DEVICENAME=iR3570;
SYSNAME=iR8070;CANON_101=119226;CANON_103=71;CANON_201=119015;CANON_203=71;CANON_DEVICENAME=iR8070;
SYSNAME=iR C5185;CANON_101=65064;CANON_102=65067;CANON_109=27085;CANON_106=37982;CANON_DEVICENAME=iR C5185;
SYSNAME=iR8070;CANON_101=101753;CANON_103=25;CANON_201=98916;CANON_203=25;CANON_DEVICENAME=iR8070;
SYSNAME=iR C4080;CANON_101=381437;CANON_102=381440;CANON_109=191394;CANON_DEVICENAME=iR C4080;
SYSNAME=iR C5185;CANON_101=144649;CANON_108=86007;CANON_102=144744;CANON_109=86052;CANON_321=31;CANON_322=34239;CANON_DEVICENAME=iR C5185;
SYSNAME=iR-ADV C5051;CANON_101=4132;CANON_108=1359;CANON_229=3;CANON_230=647;CANON_321=0;CANON_322=2123;CANON_DEVICENAME=iR-ADV C5051;
SYSNAME=iR3570;CANON_101=60103;CANON_103=2;CANON_201=52655;CANON_203=2;CANON_DEVICENAME=iR3570;
SYSNAME=iR4570;CANON_101=316656;CANON_102=316835;CANON_DEVICENAME=iR4570;
SYSNAME=iR8070;CANON_101=119416;CANON_103=71;CANON_201=119205;CANON_203=71;CANON_DEVICENAME=iR8070;
Spreadsheet: 50238d1249617457-changing-cell-format-sample-file
Sheet: Sheet1

Application | Start Time | End Time | Time Difference
Electronics | 20090718170156 | 20090718194716
Electronics | 20090718194552 | 20090718194601
Electronics | 20090718194506 | 20090718194514
Electronics | 20090718194537 | 20090718194545
Electronics | 20090718194552 | 20090718194601
Electronics | 20090718194521 | 20090718194530
Electronics | 20090718194613 | 20090718194623
Electronics | 20090718194702 | 20090718194711
Electronics | 20090718194630 | 20090718194655
Electronics | 20090718232648 | 20090718232655
Electronics | 20090718232659 | 20090718232716
Electronics | 20090718232731 | 20090718232742
Electronics | 20090718232746 | 20090718232753
Electronics | 20090718232720 | 20090718232727
Electronics | 20090718232757 | 20090718232808
Electronics | 20090718170047 | 20090718232813
Electronics | 20090719003002 | 20090719003010
Electronics | 20090719003002 | 20090719003010
Electronics | 20090718151046 | 20090719003015
Electronics | 20090718151046 | 20090718151109
Electronics | 20090718211919 | 20090718211946
Electronics | 20090718211952 | 20090718212003
Spreadsheet: 685456d1594024335-counting-data-with-two-criterias-srsmanning-schedule04072020test
Sheet: SRS

DO NOT ENTER INFORMATION INTO THIS SPREADSHEET AS FORMULATED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT ENTER INFORMATION INTO THIS SPREADSHEET AS FORMULATED
 |  |  | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00 | 2020-08-01 00:00:00
[NAME] (Days Onsite) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Days Onsite)
[NAME] (Hours Onsite) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Hours Onsite)
GT Plumbing (Mining Days Onsite) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GT Plumbing (Mining)
GT Plumbing (Mining Hours Onsite)
Oresome Air (Mining Days Onsite) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oresome Air (Mining)
Oresome Air (Mining Hours Onsite)
Misc Contractors (Mining Days Onsite) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Misc Contractors (Mining)
Misc Contractors (Mining Hours Onsite)
Total Days Onsite |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days Onsite
Total Hours Onsite |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours Onsite
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: January

 |  |  |  |  |  |  |  |  | JAN
 | NOTES
Spreadsheet: 133648d1324510752-creating-a-chart-linked-with-3-columns-power-chart-example
Sheet: Sheet1

 |  | 2 in | 131.1108613422525 | 1
 |  | 1 1/2 in. | 115.1903874495014 | 1
 |  | 1 in. | 95.97876833715107 | 1
 |  | 3/4 in. | 84.22463167428849 | 1
 |  | 1/2 in. | 70.26057091845092 | 0.8332185563593786
 |  | 3/8 in. | 61.68523628295247 | 0.7320428479728127
 |  | No. 4 | 45.17759717515764 | 0.5352431949594617
 |  | No. 8 | 33.07193690067088 | 0.3921978850441413
 |  | No. 16 | 24.21007487674427 | 0.2872435005447976
 |  | No. 30 | 17.72281216240692 | 0.2100726758045755
 |  | No. 50 | 12.96404118905177 | 0.1537821998772508
 |  | No. 100 | 9.504599484230367 | 0.1130071277270662
 |  | No. 200 | 6.936721745436823 | 0.08209213119323522
 |  | Pan | 0 | 0
Spreadsheet: louise_kitchen__24020__Corp_2002_Alloc_5
Sheet: Summary

Corporate Staff Functions
Total Corporate Staff & Services Groups Charges
2002 Plan
(In thousands)
 |  |  |  |  |  |  |  | Northern |  | ETS | Pipeline | Asset Mgmt |  |  |  |  |  |  |  | EES | EES |  |  |  |  |  |  |  |  |  |  | Total | Retained
 |  |  |  |  | TW | FGT | Citrus | Plains | NNG | HQ | Services | Corp | EOTT | EEOS | NEPCO | ENA | Europe | EGM | EIM | Retail | Wholesale | EBS | ENW | EGAS | EGF | EPI | PGG | Azurix | EREC | EPSC | Other | Allocated | At Corp
EXECUTIVE
LEGAL
RISK ASSESSMENT & CONTROL
ACCOUNTING & COMPLIANCE
CORPORATE TAX
INVESTOR RELATIONS
CORPORATE DEVELOPMENT
RISK MANAGEMENT
SAP ISC
STRATEGIC SOURCING
HUMAN RESOURCES & COMPENSATION
BENEFIT PLANS
PUBLIC AFFAIRS & ADMINISTRATION
COMMUNITY RELATIONS
EPSC |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | GRAND TOTAL
Spreadsheet: 820912d1678346973-formula-for-dates-to-quarters-7-1-2023-to-3q23-12-1-2023-to-4q23-1-1-2024-to-1q24-book1-date-to-quarter-format
Sheet: Sheet1

 |  | End Date | End Quarterv
 |  | 2025-10-01 00:00:00 | 4Q25
 |  | 2026-01-01 00:00:00 | 1Q26
 |  | 2026-04-01 00:00:00 | 2Q26
 |  | 2027-07-01 00:00:00 | 3Q27
 |  | 2024-01-01 00:00:00 | 1Q24
 |  | 2024-04-01 00:00:00 | 2Q24
 |  | 2024-04-01 00:00:00 | 2Q24
 |  | 2024-07-01 00:00:00 | 3Q24
 |  | 2025-07-01 00:00:00 | 3Q25
 |  | 2026-01-01 00:00:00 | 1Q26
Spreadsheet: 874219d1720783673-help-with-filter-formula-or-similar-please-clive-test-kaarthuul-
Sheet: Pivot Table

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Scotland | 249 | 243 | 14 | 0 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | Scotland | 700 | 697 | 296 | 1 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Scotland | 2355 | 2328 | 316 | 10 | 3
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | Scotland | 5723 | 5703 | 2543 | 17 | 10
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Scotland | 287 | 282 | 23 | 1 | 0
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | Scotland | 797 | 795 | 345 | 1 | 0
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Scotland | 2669 | 2629 | 222 | 5 | 2
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | Scotland | 6498 | 6482 | 2487 | 16 | 8
Spreadsheet: 91191d1290950511-finalize-to-my-stock-report-stock-balance-record
Sheet: 02

 | Stock Balance Record
 |  |  |  | ITEM | Tube lights
 |  |  |  | ITEM # | 02
 |  |  |  | UNITS
 |  |  |  | [NAME] |  | SECTION
 |  |  |  | EXPEDITE |  | REORDER
 |  |  |  |  |  | CURRENT BALANCE | 480
 |  |  |  |  |  | USED
 | DATE | REFERENCE | ISSUED | REC'D | ON ORDER | TO DATE | BALANCE
 |  |  |  |  |  | OPENING BALANCE | 400
 | 25.11.10 |  | 45 |  |  | 355 | 355
 | 26.11.10 |  | 75 |  |  | 430 | 280
 | 26.11.10 |  |  | 200 |  | 430 | 480
Spreadsheet: 694909d1599882460-time-sheet-formula-7-minute-rule-time-bvj-
Sheet: Sheet1

Old = tenths of an hour
Time In | Target Time out | Earliest out | Latest Out | Actual out | Total Time
07:02:00 |  |  |  | 16:00:00
New = 7 minute rule
Time In | Time Out | Total Time
07:02:00 | 15:25:00
Spreadsheet: 124906d1318705026-ge-discription-from-numbers-hkm-purchase-order
Sheet: Invoice

Cash
Check |  |  |  |  |  |  |  |  |  |  | PO NO. | 01
Credit
Other
 |  |  | 123 Where ever Road |  |  |  |  |  |  | PURCHASE ORDER
 |  | SUPPLIER |  |  |  |  |  |  |  |  | Misc
 |  | Name | The Other Guy |  |  |  |  |  | DATE |  | DATE
 |  | Address
 |  | City |  | Prov. |  |  |  |  |  |  | PURCHASER | V.Morrison
 |  | Phone
 |  |  |  |  |  |  |  |  | Delivery Date
 |  | ITEM NO. | [NAME] |  |  |  |  |  |  | QTY | UNIT PRICE | TOTAL
 |  | 100 | c |  |  |  |  |  |  | 100
 |  |  | c |  |  |  |  |  |  | 100
 |  |  | c |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  | SubTotal
 |  |  |  |  |  |  |  |  |  |  | Shipping
 |  | Payment | Check |  |  |  |  |  | Tax Rate(s) |  | 0.07
 |  |  |  |  |  |  |  |  |  |  | 0.05
 |  | Comments |  |  |  |  |  |  |  |  | TOTAL
 |  | Name
 |  | CC # |  |  |  |  |  |  | Office Use Only
 |  | Expires
 |  | COMMENTS:
 |  |  | We thank you for your business
Spreadsheet: 167310d1341948795-trying-to-create-a-summary-page-testbooka
Sheet: Area 5

Area 4
Effect | Status | Work order | Notes
Effect 1E | In Service
Effect 2E | In Service
Effect 3E | In Service
Effect 4E | In Service
Effect 5E | In Service
Effect 6E | In Service
Effect 7E | OOS |  | [NAME]
Spreadsheet: 57691295-2c8c-4fb6-8ae4-22e160938c01
Sheet: PET

 |  | Potential Evapotranspiration Worksheet (Thornthwaite method)
 |  | Project Name:
 |  | Location of Temperature Data:
 |  | Starting Year of Data Record:
 |  | Ending Year of Data Record:
 |  | Period of Record (years):
 |  | Source of Data:
 | Site Latitude (degrees)
 | Calculated PET: |  |  |  |  | inches
 |  |  |  | Mean Monthly Temperature (degrees F) | Daylight Hours / 12 | Heat Index | Calculated PET (inches)
 |  |  | January
 |  |  | February
 |  |  | March
 |  |  | April
 |  |  | May
 |  |  | June
 |  |  | July
 |  |  | August
 |  |  | September
 |  |  | October
 |  |  | November
 |  |  | December
 |  |  |  |  | Total =
Spreadsheet: 162784d1340060664-copy-of-managers-clients-info-from-master-list-database-example
Sheet: CM

Name | SSN | CAT | VASH | Refer Date | [NAME] | Exit Date | Recert Date | Exit Date | Recert Date | Exit Date | Case Mgr | Referral Source | M/F | OIF/ OEF | Spouse | # M Dep | # F Dep | Total # Dep | Total # M | Total # F | Total Household | Spouse Disabled | Child >18 Disabled | <30% AMI | Chronically Homeless | Comments
Work Space Here
Mirror Active (no exited dates) clients here for just [NAME]
Spreadsheet: 86943d1286895092-percentage-in-a-pivot-table-example
Sheet: example

Emp | Equip1 | Equip2 |  |  | Emp | Equip1 | Equip2
a | 5 | 20 |  |  | a
b | 3 | 1 |  |  | b
 |  |  |  |  |  | Values
 |  |  |  |  | Emp | Sum of %equip1 | Sum of %equip2
 |  |  |  |  | a | 0.2 | 0.8
 |  |  |  |  | b | 0.75 | 0.25
 |  |  |  |  | Grand Total | 0.2758620689655172 | 0.7241379310344828
Spreadsheet: 450660d1457832409-reference-table-from-another-sheet-table-from-other-sheet
Sheet: Original sheetNames

Name | Company | Price
Name 12 | Company 91 | 68
Name 29 | Company 4 | 40
Name 41 | Company 55 | 90
Name 45 | Company 48 | 93
Name 45 | Company 23 | 41
Name 47 | Company 79 | 38
Name 48 | Company 87 | 75
Name 50 | Company 76 | 90
Name 57 | Company 68 | 90
Name 65 | Company 87 | 95
Name 66 | Company 79 | 65
Name 72 | Company 13 | 85
Name 83 | Company 76 | 77
Name 88 | Company 90 | 71
Name 89 | Company 64 | 14
Spreadsheet: 141146d1329130054-problem-counting-text-in-excel-example
Sheet: Sheet1

Name | Sale | Yes | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | No
Sue | Yes
[NAME] | Yes
Adam | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Sue | Yes
[NAME] | Yes
Adam | Yes
[NAME] | No
[NAME] | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Sue | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | No
[NAME] | Yes
Adam | Yes
Adam | Yes