tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 09279f50-ca70-4529-a1b2-2d9bb8cc538b
Sheet: Accident Value Benefit

 | Total Value of Fatalities and Accidents
 | Fatal and Injury Accidents
 | (Moderate to Serious Injuries)
 | AIS Rating | # of Accidents | Value of Injury / Fatality | Project Value       Reduced Injuries / Fatalities
 | 0 | 0 | 0
 | 1 | 0 | 27300
 | 2 | 2 | 427700
 | 3 | 2 | 955500
 | 4 | 0 | 2420600
 | 5 | 0 | 5396300
 | 6 | 0.25 | 9100000
 | Subtotals | 5
 | For details on Cost Benefit Analysis and Background Calculations see  http://www.cityofarcata.org/departments/public-works/parks/rail-with-trail
 | ● The City has data from 2007 and 2008 that totals 34 injury accidents within a 1.5 mile buffer of the proposed trail (including 3 fatalities which were all within 10 feet of the proposed trail).
 | ● As a conservative estimate we are assuming that there would be a 25% reduction in injury accidents and no more than 1 fatal crash every 4 years.
 | ● The values are calculated at 4 injury accidents per year avoided with construction of the trail and .25 fatal accidents per year.
 | ● Half of the injury accidents are calculated at an AIS rating of 2 and half are calculated at an AIS rating of 3 and the fatality is calculated at an AIS rating of 6
 | ● Value of Statistical Life has been derived from the Treatment of the economic Value of a Statistical Life in Departmental Analyses (2008 revised guidance and 2011 update) as
 | outlined on pages 1-3 of the TIGER BCA Resource Guide 2013 Supplement
 |  |  |  |  |  | 5041400
Spreadsheet: 101648d1299734887-inventory-how-to-reset-input-variable-without-changing-the-output-cells-value-ieinventory
Sheet: Inventory

Item | Quantity | Digikey Item# |  |  | Item | Quantity | Digikey Item #
Resistors |  |  |  |  | Mosfet & Volt. [NAME].
220hz 1/8w |  |  |  |  | 7805 VR | 234
1K 1/8w | 450 |  |  |  | L78L05 VR | 78
4.7K 1/8w | 0 |  |  |  | LT1121 VR | 137
10K 1/8w | 0 |  |  |  | SITM08041017 | 132
220hz 1/2w | 2000 |  |  |  | IRF510 Mosfet | 5
1k 1/2w | 700 |  |  |  | S8025N SCR | 50
4.7k 1/2w | 20 |  |  |  | S6010LS2 SCR | 42
10k 1/2w | 850 |  |  |  | Crystal Osc. 20.00-20 | 12
Potentiometers |  |  |  |  | Connectors
10k 18MPT | 110 |  |  |  | Binding Posts | 28
20k 18MPT | 44 |  |  |  | 12v Batt. Terminals- Red | 300
50k 18MPT | 4 |  |  |  | 12v Batt. Terminals- Blue | 74
 |  |  |  |  | Ring Lugs- Red | 75
LEDs & Diodes |  |  |  |  | Ring Lugs- Blue | 0
LED double digit | 5 |  |  |  | WEGOs | 223
LED single digit | 5
5mm Green | 0 |  |  |  | Capacitors
5mm Red | 21 |  |  |  | 25v 10uf | 10
5mm Blue | 0 |  |  |  | 25v 220uf | 7
5mm Yellow | 0 |  |  |  | 25v 330uf | 14
12mm Blue | 135 |  |  |  | 25v 470uf | 5
5mm Holsters | 25 |  |  |  | 25v 1000uf | 70
IN4007 Diode | 120 |  |  |  | 35v 4.7uf | 400
 |  |  |  |  | 35v 100uf | 10
Logic |  |  |  |  | 50v 20pf | 59
PIC 16F628A | 124 |  |  |  | 50v .1uf | 100
PIC 16F677 | 2 |  |  |  | 50v .33uf | 84
TI-07AR04M Decoder | 4 |  |  |  | 50v 1uf | 11
8-pin sockets | 48 |  |  |  | 50v 2.2uf | 12
18-pin sockets | 0 |  |  |  | 50v 3.3uf | 11
 |  |  |  |  | 50v 4.7uf | 11
Relays, Timers, Radios |  |  |  |  | 50v 10uf | 14
5vDC Relay | 65 |  |  |  | 50v 22uf | 14
12vDC Relay | 9 |  |  |  | 50v 33uf | 15
Mechanical Timer | 4 |  |  |  | 50v 47uf | 9
434 mhz Receiver | 62
434 mhz Transmitter | 49 |  |  |  | Buttons & Switches
LAA110 Relay | 116 |  |  |  | [NAME] | 3
 |  |  |  |  | 17MOMM Button | 49
 |  |  |  |  | 4-Prong Button | 0
 |  |  |  |  | 17SLDDD Switch | 55
 |  |  |  |  | Toggle Switch | 3
Printed Circuit Boards | PCB Quantity | [NAME]
Hollywood Timer | 95 | 1
GPS Board | 0 | 5
MOSFET Board | 90 | 5
PIC Board | 30
Simulator Control | 0
[NAME] | 49
Tattoo Receiver | 0
[NAME] | 0
Spreadsheet: 748446d1632148723-cell-formatting-based-on-vlookup-and-multiple-cell-values-upload-sheet
Sheet: Lookup

Category | Ref | Key Metric (Effectiveness / Coverage) | Red (<) | Amber (<>) | Green (>)
Asset Management | GOV.AM1 | Business, EUC and IT applications and assets with an assigned business and system owner | 0.9 | 90-99% | 0.99
 | GOV.AM1.1 | Business, EUC and IT applications and assets onboarded to an asset inventory (or CMDB) | 0.95 | 95-100% | 1
 | GOV.AM1.1.1 | Business and IT applications and assets identified (manually or automatically) | N/A | N/A | N/A
 | GOV.AM1.1.2 | EUC applications identified (manually or automatically) | N/A | N/A | N/A
Programme | GOV.PR1 | Security programme workstreams' progressing according to plan | 0.85 | 85-100% | 1
IS Cost | GOV.CO1 | Information security controls budget vs actual cost YTD | 0.9 | 90-100% | 1
 | GOV.CO2 | Information security budget vs IT budget | 0.15 | 15-30% | 0.3
Spreadsheet: 2043d968-40d4-4b9b-90a9-5ee332505104
Sheet: referrals by domain

Referrals report excludes internal referrals.
Full-Text Downloads for 2006-02-02 through 2006-06-30 for DigitalCommons@University of Rhode Island
Domain | URL | Count
Google total |  | 358
www.google.com | http://www.google.com | 140
scholar.google.com | http://scholar.google.com | 52
www.google.co.uk | http://www.google.co.uk | 30
www.google.fr | http://www.google.fr | 19
www.google.ca | http://www.google.ca | 17
www.google.ie | http://www.google.ie | 15
www.google.de | http://www.google.de | 13
www.google.com.au | http://www.google.com.au | 11
64.233.179.104 | http://64.233.179.104 | 6
www.google.com.vn | http://www.google.com.vn | 5
www.google.it | http://www.google.it | 5
www.google.es | http://www.google.es | 5
66.249.93.104 | http://66.249.93.104 | 4
www.google.com.tr | http://www.google.com.tr | 4
www.google.com.sa | http://www.google.com.sa | 3
www.google.co.ve | http://www.google.co.ve | 3
72.14.207.104 | http://72.14.207.104 | 3
66.102.9.104 | http://66.102.9.104 | 3
www.google.co.za | http://www.google.co.za | 3
www.google.dk | http://www.google.dk | 2
[NAME] | http://www.google.com.eg | 2
www.google.com.tw | http://www.google.com.tw | 2
www.google.co.in | http://www.google.co.in | 2
www.google.co.nz | http://www.google.co.nz | 2
66.102.7.104 | http://66.102.7.104 | 2
www.google.be | http://www.google.be | 2
www.google.com.pk | http://www.google.com.pk | 2
www.dogpile.com | http://www.dogpile.com | 2
www.google.com.br | http://www.google.com.br | 2
[NAME] | http://www.google.pl | 2
search.hp.netscape.com | http://search.hp.netscape.com | 1
www.google.ru | http://www.google.ru | 1
searcht.netscape.com | http://searcht.netscape.com | 1
www.google.pt | http://www.google.pt | 1
www.google.ch | http://www.google.ch | 1
www.google.fi | http://www.google.fi | 1
mysearch.myway.com | http://mysearch.myway.com | 1
www.google.hr | http://www.google.hr | 1
suche.aol.de | http://suche.aol.de | 1
www.google.nl | http://www.google.nl | 1
www.google.co.uz | http://www.google.co.uz | 1
www.google.com.ph | http://www.google.com.ph | 1
www.google.co.ma | http://www.google.co.ma | 1
www.google.bg | http://www.google.bg | 1
www.answers.com | http://www.answers.com | 1
72.14.203.104 | http://72.14.203.104 | 1
www.google.co | http://www.google.co | 1
72.14.209.104 | http://72.14.209.104 | 1
www.google.com.ezp1.harvard.edu | http://www.google.com.ezp1.harvard.edu | 1
www.google.cn | http://www.google.cn | 1
216.239.51.104 | http://216.239.51.104 | 1
scholar.google.com.br | http://scholar.google.com.br | 1
www.google.co.th | http://www.google.co.th | 1
aolsearch.aol.co.uk | http://aolsearch.aol.co.uk | 1
Total |  | 387
Spreadsheet: 104260d1301917678-simple-sumproduct-help-i-think-sumpr_help
Sheet: Summary

 | Test | Qty | Diff | P
2010-10-31 00:00:00
Spreadsheet: f6a9883e-48b9-4ef9-b28f-f44764d19cb1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
C1QFX | Test | C1QFX | C1q Complement, Functional, Serum | C1Q Complement, Functional, S | Turbidimetry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Immediately after drawing the specimen, place the tube on wet ice. 2. Spin down and separate serum from clot. 3. Immediately freeze specimen. Additional Information: Fasting preferred. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Serum gel tube | 34-63 U/mL | Monday through Saturday; [NAME] with a 3 p.m. cutoff | Same day/1 day | 3 days | 1 | 86161 |  |  |  |  | Rochester
C1QFX | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
C1QFX | Result | C1QFX | C1Q Complement, Functional, S | C1Q Complement, Functional, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 754878d1636552294-searching-a-value-different-tabs-using-some-conditionals-1636493371-busca-com-indireto-eba
Sheet: LISTAS

 | FILIAIS | DESTINOS | VEÍCULOS
 | SP | ARACAJÚ - SE | IVECO | VAN
 | GO | ATIBAIA - SP | CAMINHÃO VUK  (4,8m)
 | SALVADOR | BELÉM - MA | CAMINHÃO TRUCK  (10m)
 | PR | BELO HORIZONTE - MG | CARRETA (14,5m)
 |  | BRAGANÇA PAULISTA - SP
 |  | BRASÍLIA - DF
 |  | CAMPINAS - SP
 |  | CAMPO GRANDE - GO
 |  | CAMPOS DO JORDÃO - SP
 |  | CURITÍBA - PR
 |  | FLORIANÓPOLIS - SC
 |  | FORTALEZA - CE
 |  | FOZ DO IGUAÇU - PR
 |  | GOIÂNIA - GO
 |  | [NAME]
 |  | ILHA DE COMANDATUBA - BA
 |  | ITATIBA - SP
 |  | ITÚ - SP
 |  | JOÃO PESSOAS - PA
 |  | JUNDIAÍ - SP
 |  | MOGI DAS CRUZES - SP
 |  | PORTO ALEGRE - RS
 |  | [NAME] DO FORTE - BA
 |  | RECIFE - PE
 |  | RIBERÃO PRETO - SP
 |  | RIO DE JANEIRO - RJ
 |  | SALVADOR - BA
 |  | SÃO PAULO - SP
 |  | SOROCABA - SP
 |  | VALINHOS - SP
 |  | VINHEDO - SP
 |  | VITÓRIA - ES
Spreadsheet: 7b44d3bf-0960-4699-8aba-ad11c68776c4
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das AHV-Rentenalter wird erhöht.
 | [NAME]:
Antwort | männlich | weiblich
[NAME] | 0.35 | 0.28
Neutral/Weiss nicht | 0.12 | 0.13
[NAME] | 0.52 | 0.58
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 1071ac1d-21c0-40b1-b36f-a598fe2f9eb1
Sheet: Sheet1

Spine Point | Spinal Salary |  | [NAME] (£)
 |  |  | Grade 1 |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Grade 5 |  |  | Grade 6 |  |  | Grade 7 |  |  | [NAME] |  |  | Grade 9 |  |  | Grade 10
 |  |  | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate |  | Holiday Pay | Total
 |  |  | From 1 December 2013 all casual workers must not be paid below the New Living Wage rate of £8.48 inc holiday pay
1 | 13621
2 | 13977
3 | 14344
4 | 14665
5 | 15054
6 | 15456
7 | 15814
8 | 16252
9 | 16705
10 | 17184
11 | 17678
12 | 18185
13 | 18708
14 | 19247
15 | 19802
16 | 20374
17 | 20972
18 | 21597
19 | 22240
20 | 22927
21 | 23585
22 | 24289
23 | 25013
24 | 25759
25 | 26527
26 | 27318
27
28 | 28972
29 | 29837
30 | 30728
31 | 31644
32 | 32590
33 | 33562
34 | 34565
35
36 | 36661
37 | 37756
38 | 38907
39 | 40046
40 | 41242
41 | 42476
42
43 | 45053
44 | 46400
45 | 47787
46 | 49216
47 | 50688
48 | 52204
49 | 53765
50 | 55375
51 | 57031
52 | 58738 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
53 | 60496 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
54 | 62306 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
55 | 64171 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
56 | 66092 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
57 | 68069 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
58 | 70107 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
Spreadsheet: 794350d1662001185-two-column-list-descending-dates-and-ids-find-next-date-in-list-matching-row-id-difference-next-data-row-by-id-rows-sorted-by-date-desc-
Sheet: Transform Step

Employee ID | Date/Time Opened | YOUR MAGIC FORMULA! |  |  |  |  |  | Employee ID | [NAME]
18 | 2022-08-27 12:14:00 | 2022-08-29 00:00:00 |  |  |  |  |  | 18 | 2022-08-29 00:00:00
21 | 2022-08-27 12:14:00 | NA |  |  |  |  |  | 21 | 2022-08-27 00:00:00 |  | Employee ID | Date/Time Opened
4 | 2022-08-27 12:13:00 | NA |  |  |  |  |  | 4 | 2022-08-27 00:00:00 |  | 1 | 44800.50972222222
5 | 2022-08-27 12:13:00 | NA |  |  |  |  |  | 5 | 2022-08-27 00:00:00 |  | 3 | 44800.50972222222
6 | 2022-08-27 12:13:00 | NA |  |  |  |  |  | 6 | 2022-08-27 00:00:00 |  | 4 | 44800.50902777778
7 | 2022-08-27 12:13:00 | NA |  |  |  |  |  | 7 | 2022-08-27 00:00:00 |  | 5 | 44800.50902777778
9 | 2022-08-27 12:13:00 | 2022-08-28 00:00:00 |  |  |  |  |  | 9 | 2022-08-28 00:00:00 |  | 6 | 44800.50902777778
9 | 2022-08-28 00:00:00 | NA |  |  |  |  |  | 11 | 2022-08-28 00:00:00 |  | 7 | 44800.50902777778
11 | 2022-08-28 00:00:00 | NA |  |  |  |  |  | 12 | 2022-08-28 00:00:00 |  | 9 | 44800.50902777778
12 | 2022-08-28 00:00:00 | NA |  |  |  |  |  | 13 | 2022-08-28 00:00:00 |  | 9 | 44801
13 | 2022-08-28 00:00:00 | NA |  |  |  |  |  | 14 | 2022-08-29 00:00:00 |  | 11 | 44801
14 | 2022-08-27 12:13:00 | 2022-08-28 00:00:00 |  |  |  |  |  | 16 | 2022-08-29 00:00:00 |  | 12 | 44801
14 | 2022-08-28 00:00:00 | 2022-08-29 00:00:00 |  |  |  |  |  | 17 | 2022-08-29 00:00:00 |  | 13 | 44801
14 | 2022-08-29 00:00:00 | NA |  |  |  |  |  | 19 | 2022-08-29 00:00:00 |  | 14 | 44800.50902777778
16 | 2022-08-29 00:00:00 | NA |  |  |  |  |  |  |  |  | 14 | 44801
17 | 2022-08-29 00:00:00 | NA |  |  |  |  |  |  |  |  | 14 | 44802
19 | 2022-08-29 00:00:00 | NA |  |  |  |  |  |  |  |  | 16 | 44802
18 | 2022-08-29 00:00:00 | NA |  |  |  |  |  |  |  |  | 17 | 44802
 |  |  |  |  |  |  |  |  |  |  | 19 | 44802
 |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 759079d1639297724-vlookup-average-with-same-results-sometimes-averagelookup
Sheet: Pretty Sheet

Monthly Average Sales
Business | Item Number | January | February | March
(uses unique function, removed for testing sake)
hals paints | 1025L | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
premium supplier | 1025L | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
All Trace | 1025L | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
Safety Industries | 1025L | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
Murfies | 1025L | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
hals paints | B2000 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
premium supplier | B2000 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
All Trace | B2000 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
Safety Industries | B2000 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
Murfies | B2000 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
hals paints | B2010 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
premium supplier | B2010 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
All Trace | B2010 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
Safety Industries | B2010 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
Murfies | B2010 | INSERT AVERAGE HERE | INSERT AVERAGE HERE | INSERT AVERAGE HERE
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Agency Conference

 |  |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Fair-Hearings & Appeals
Activity Name | Agency Conference
Activity Description / Purpose | Conducting an informal meeting to address issues or concerns the client has regarding their eligibility
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Receive client request for conference
Schedule conference
Prepare case record
Perform conference
Determine accuracy of eligibility decision
Update case record
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 599232d1542913983-formula-for-extracting-data-according-the-criteria-excel
Sheet: sheet1

Code | Days | Value | %
RHG | 1 | 5 | 3
FAR | 2 | 10 | 5
GHM | 3 | 15 | 8
LMN | 4 | 20 | 10
TRU | 5 | 25 | 12
ZMN | 6 | 30 | 15
 | 7 | 35 | 18
 | 8 | 40 | 20
 | 9 | 50 | 25
 | 10 | 60
 | 11 | 70
 | 12 | 80
 |  | 90
 |  | 100
Spreadsheet: 708201d1607671043-count-the-number-of-cell-rows-address-from-top-to-bottom-1211
Sheet: Sheet2

Title |  |  | Min address | [NAME] address
1 |  | 1 | 3 | 6
aa
bb
cc
Other
Sub-Total
Total
2
aa
bb
cc
dd
ee
ff
gg
hh
Other
Sub-Total
Total
3
dd
ee
ff
gg
hh
Other
Sub-Total
Total
Spreadsheet: 171970d1343931990-multiple-if-statements-with-and-functions-for-range-of-values-usc-2012
Sheet: Sheet1

Tax | Annual | Monthly | Weekly | %
USC Rate1: | 10036 | 836.3333333333334 | 193 | 0.02
USC Rate2: | 16016 | 1334.666666666667 | 308 | 0.04
USC Rate3: | 16016 | 1334.666666666667 | 308.01 | 0.07
 |  |  | Cumm | USC | Due @ |  | Due @ |  | Due @
Date | Period | Gross | Gross | USC Rate1: | USC Rate1: | USC Rate2: | USC Rate2: | USC Rate3: | USC Rate3: | Total Due
2012-01-07 00:00:00 | 1 | 500 | 500 | 193 | 3.86 | 115 | 4.600000000000001 | 192 | 13.44 | 21.9
2012-01-14 00:00:00 | 2 | 400 | 900 | 386 | 7.72 | 230 | 9.200000000000001 | 284 | 19.88 | 36.8
2012-01-21 00:00:00 | 3 | 300 | 1200 | 579 | 11.58 | 345 | 13.8 | 276 | 19.32 | 44.7
2012-01-28 00:00:00 | 4 | 586 | 1786 | 772 | 15.44 | 460 | 18.4 | 554 | 38.78 | 72.62
2012-02-04 00:00:00 | 5 | 412 | 2198 | 965 | 19.3 | 575 | 23 | 658 | 46.06 | 88.36
2012-02-11 00:00:00 | 6 | 752 | 2950 | 1158 | 23.16 | 690 | 27.6 | 1102 | 77.14 | 127.9
2012-02-18 00:00:00 | 7 | 371 | 3321 | 1351 | 27.02 | 805 | 32.2 | 1165 | 81.55000000000001 | 140.77
2012-02-25 00:00:00 | 8 | 310 | 3631 | 1544 | 30.88 | 920 | 36.8 | 1167 | 81.69000000000001 | 149.37
2012-03-03 00:00:00 | 9 | 352 | 3983 | 1737 | 34.74 | 1035 | 41.4 | 1211 | 84.77000000000001 | 160.91
2012-03-10 00:00:00 | 10 | 500 | 4483 | 1930 | 38.6 | 1150 | 46 | 1403 | 98.21000000000001 | 182.81
2012-03-17 00:00:00 | 11 | 400 | 4883 | 2123 | 42.46 | 1265 | 50.6 | 1495 | 104.65 | 197.71
2012-03-24 00:00:00 | 12 | 300 | 5183 | 2316 | 46.32 | 1380 | 55.2 | 1487 | 104.09 | 205.61
2012-03-31 00:00:00 | 13 | 586 | 5769 | 2509 | 50.18 | 1495 | 59.8 | 1765 | 123.55 | 233.53
2012-04-07 00:00:00 | 14 | 412 | 6181 | 2702 | 54.04 | 1610 | 64.4 | 1869 | 130.83 | 249.27
2012-04-14 00:00:00 | 15 | 752 | 6933 | 2895 | 57.9 | 1725 | 69 | 2313 | 161.91 | 288.8100000000001
2012-04-21 00:00:00 | 16 | 371 | 7304 | 3088 | 61.76 | 1840 | 73.60000000000001 | 2376 | 166.32 | 301.6800000000001
2012-04-28 00:00:00 | 17 | 341 | 7645 | 3281 | 65.62 | 1955 | 78.2 | 2409 | 168.63 | 312.45
2012-05-05 00:00:00 | 18 | 477 | 8122 | 3474 | 69.48 | 2070 | 82.8 | 2578 | 180.46 | 332.74
2012-05-12 00:00:00 | 19 | 469 | 8591 | 3667 | 73.34 | 2185 | 87.4 | 2739 | 191.73 | 352.47
2012-05-19 00:00:00 | 20 | 500 | 9091 | 3860 | 77.2 | 2300 | 92 | 2931 | 205.17 | 374.37
 |  | 9091 |  | Spot Check | 3860 | 0.02 | 77.2
 |  |  |  |  | 2300 | 0.04 | 92
 |  |  |  |  | 2931 | 0.07 | 205.17
 |  |  |  |  |  |  | 374.37
Spreadsheet: 864894d1712046283-2-if-formulas-causing-problems-sample
Sheet: Sample

 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Start Month | [NAME] | Employee # | Employee Name | Group Band | Legal Company code | Subarea | Location | FTE-% | Type | Reduced Time | Reduced Time by | Salary with Bonus and Staff Expenses | January | February | March | April | May | June | July | August | September | October | November | December |  |  |  | Monthly salary incl. [NAME] and merit DKK | Monthly incentive incl. [NAME] DKK | Monthly staff expenses incl. merit DKK
1 | PD Solutions & Modules | 2008 | Test Test | 07 | GMA | White Collar |  | 1 | Employee | 0.5 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | First Attemp |  |  | 100 | 25 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Second Attemp
 |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 75 | 75 | 75 | Expected result
Spreadsheet: andy_zipper__261__Broker detail 4-25-01
Sheet: Broker Data

[NAME] for 4/20/2001:
Broker: | Commodity: | Daily Deal Count: | LTD Deal Count: | Daily Failed Transaction Count: | LTD Failed Transaction Count:
APB Energy, Inc. | U.S. Nat Gas | 4 | 6 | 0 | 2
 | U.S. Power | 2 | 7 | 0 | 1
 | Subtotal
Natsource LLC | U.S. Nat Gas | 3 | 11 | 0 | 0
 | U.S. Power | 11 | 42 | 1 | 10
 | Subtotal
Power Merchants | U.S. Nat Gas | 0 | 1 | 0 | 1
 | U.S. Power | 0 | 0 | 0 | 0
 | Subtotal
 | Total
Spreadsheet: 212205d1360068024-leaving-a-cell-blank-unless-referenced-cells-contain-a-value-test-time-card-05-feb-13
Sheet: Time Card

 | Time Card
 | WEEK ENDING:
 | WEEK 1 |  |  |  |  |  |  |  | NOTES FOR EACH LINE
 | Day | Date | Start | End | Lunch | Vacation | Personal | Total
 | Sunday |  | 8 | 4.5 | 0.5 | 0 | 0 |  | TYPICAL DAY
 | Monday |  | 8 | 12 | 0 | 0 | 0 |  | 1/2 DAY SHOWING '12' ERROR
 | Tuesday |  | 1900-01-08 00:00:00 | 1900-01-04 12:00:00 | 12:00:00 | 00:00:00 | 00:00:00 |  | CUSTOM FORMAT H:MM, TIMES ENTERED ARE 8.0, 4.5, .5 IN D-F RESPECTIVELY
 | Wednesday |  | 8 | 4.5 | 0.5 | 0 | 0 |  | CUSTOM FORMAT [H]:MM, TIMES ENTERED ARE 8.0, 4.5, .5 IN D-F RESPECTIVELY
 | Thursday |  | 0 | 0 | 0 | 0 | 0
 | Friday |  | 0 | 0 | 0 | 0 | 0
 | Saturday |  | 0 | 0 | 0 | 0 | 0
 | Total hours
 | WEEK 2
 | Day | Date | Start | End | Lunch | Vacation | Personal | Total
 | Sunday |  | 0 | 0 | 0 | 0 | 0
 | Monday |  |  |  | 0 | 0 | 0
 | Tuesday |  |  |  | 0 | 0 | 0
 | Wednesday |  |  |  | 0 | 0 | 0
 | Thursday |  |  |  | 0 | 0 | 0
 | Friday |  |  |  | 0 | 0 | 0
 | Saturday |  | 0 | 0 | 0 | 0 | 0
 | Total hours
 |  |  |  |  |  |  | BI-WEEKLY TOTAL: