tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: Scharf

Employee Name: |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flex Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Hours |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal Business
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carryover Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purchased Days |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vac | Flex | Sick | PB | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOURS | HOURS | HOURS | HOURS | Days
 | 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 | Taken | Taken | Taken | Taken | Taken
Jan |  |  | H
Feb
Mar
April
May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
June
July |  |  |  | H
Aug
Sept |  |  |  |  | H
Oct
Nov |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
Dec |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subtotals:
Categories |  |  |  | Symbols to Enter |  |  |  |  | Notes:
Vacation HOURS |  |  |  | (# of hours)V |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining Time:
Sick HOURS |  |  |  | (# of hours)S |  |  |  |  | 2
[NAME] |  |  |  | (# of hours)FH |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining Days:
Personal Business |  |  |  | (# of hours)PB |  |  |  |  | 4
Other Days |  |  |  |  |  |  |  |  | 5
Funeral DAYS |  |  |  | FL |  |  |  |  | 6
Leave DAYS |  |  |  | L |  |  |  |  | 7
Other DAYS |  |  |  | O |  |  |  |  | 8
Half Funeral DAYS |  |  |  | HFL |  |  |  |  | 9
Half Leave DAYS |  |  |  | HL |  |  |  |  | 10
Half Other DAYS |  |  |  | HO
[NAME] |  |  |  | VTO |  |  |  | 1 Volunteer Time Off Day allowed
Spreadsheet: 842562d1694606702-countifs-giving-0-value-when-total-is-known-training_report-forum-aligw
Sheet: Master Data

Report Date: | 2023-08-31 00:00:00
COST CENTRE | INC123 Unconscious Bias
504360300
504330700 |  |  | STATUS | INC123 Unconscious Bias
504350800 |  |  | Completed
504250600 | 2023-06-19 00:00:00 |  | Expired
504270200 | 2022-02-16 00:00:00 |  | Not completed
504250700 | 2023-05-16 00:00:00 |  | Total
504240300 | 2023-05-18 00:00:00 |  | Percentage of Completed Courses
504310000
504320000
504261414
504410200 | 2023-05-29 00:00:00
504340600 | 2023-05-26 00:00:00
504260400 | 2023-02-03 00:00:00
504110000
504250400
504630100 | 2023-05-26 00:00:00
504230300 | 2023-08-15 00:00:00
Spreadsheet: 877105d1723787774-popultate-cells-based-on-cell-value-of-a-different-sheet-del-sched-to-po-help
Sheet: PO

PURCHASE ORDER
PO REFERENCE |  |  |  |  | SUPPLIER | xx
MYOB # |  |  |  |  |  | xx
DATE |  |  |  |  |  | xx
Line | AMG CODE | VAN BEEST CODE | [NAME] |  |  |  | QTY | COST | EXT COST
1 | SSB047GP |  | Shackle Bow Gr Pin 4.7tn |  |  |  | 25 | 8.69
2 | SSB065GP |  | Shackle Bow Gr Pin 6.5tn |  |  |  | 16 | 12.08
3 | SSB095GP |  | Shackle Bow Gr Pin 9.5tn |  |  |  | 18 | 24.65
4 | SSB135GP |  | Shackle Bow Gr Pin 13.5tn |  |  |  | 29 | 49.09
5 | SSSB015GP |  | Shackle Safety Bow Gr Pin 1.5t |  |  |  | 30 | 4.61
6 | SSSB020GP |  | Shackle Safety Bow Gr Pin 2tn |  |  |  | 62 | 6
7 | SSSB032GP |  | Shackle Safety Bow Gr Pin3.2tn |  |  |  | 19 | 9.41
8 | SSSB095GP |  | Shackle Safety Bow Gr Pin9.5tn |  |  |  | 2 | 30.01
9 | SSSB120GP |  | Shackle Safety Bow Gr Pin 12tn |  |  |  | 5 | 46.35
10 | SSSB135GP |  | Shackle Safety Bow GrPin13.5tn |  |  |  | 8 | 58.66
11 | SSSB350GP |  | Shackle Safety Bow Gr Pin 35tn |  |  |  | 5 | 171.75
12 | SSSBMGP-4.75T |  | GP Big Mouth Shackle 4.75t |  |  |  | 1 | 25
13 | SSSBMGP-8.5T |  | GP Big Mouth Shackle 8.5t |  |  |  | 99 | 56.34
14 | SSSBMGP-12T |  | GP Big Mouth Shackle 12t |  |  |  | 120 | 99.87
15 | SSSBMGP-55T |  | GP Big Mouth Shackle 55t |  |  |  | 2 | 533.37
16 | SSSBMGP-75T |  | GP Big Mouth Shackle 75t |  |  |  | 6 | 1222.66
17 | SSSB018GP6033 |  | Green Pin Safety Shackles Sling P-6033 18tn |  |  |  | 17 | 250.51
18 | SSSB030GP6033 |  | Green Pin Safety Shackles Sling P-6033 30tn |  |  |  | 8 | 306.28
Spreadsheet: 601324d1544346024-formula-to-calculate-mtbf-and-mttr-ikk-bd-monitoring-new-mttr-and-mtbf
Sheet: MTBF

 |  | Date HH:MM | Date HH:MM | HH:MM |  | HH:MM
 | Equip No | First Date | Last Date | Span | Count | [NAME]
 | G46
 | G52
 | G60
 | [NAME]
 | G79
 | G82
 | [NAME]
 | G55
 | G56
 | G57
 | G59
 | G61
 | [NAME]
 | G68
 | G74
 | [NAME]
 | [NAME]
 | G83
 | G50
 | G51
 | G54
 | G64
 | G71
 | G76
 | G81
 | G65
 | G66
 | G67
 | G75
 | G73
 | G62
 | G53
 | G72
 | G77
 | G69
 | G84
 | Test | 2018-01-01 00:00:00 | 2018-01-02 00:00:00 |  | 2 |  |  | <<<<< remove complete row when satisfied
Spreadsheet: a7cd3807-8e86-404b-9d28-f5144e12b4a3
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 67018 | 73183 | 78904 | 79137
15 - 65 | 347763 | 346793 | 345336 | 345091
65 und mehr | 115000 | 118865 | 125508 | 129762
Insgesamt | 529781 | 538841 | 549748 | 553990
%
unter 15 | 12.65013279071919 | 13.58155745386858 | 14.35275799093403 | 14.28491489016047
15 - 65 | 65.64278447131929 | 64.3590595370434 | 62.81714531021486 | 62.29191862669001
65 und mehr | 21.70708273796154 | 22.05938300908802 | 22.83009669885111 | 23.42316648314952
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 19.27117030851471 | 21.10279042541228 | 22.84847221256979 | 22.93221208318965
Altenquotient | 33.06849779878826 | 34.27548998970568 | 36.34373479741469 | 37.60225563691895
Gesamtquotient | 52.33966810730296 | 55.37828041511796 | 59.19220700998448 | 60.53446772010861
Gebietsstand: | 31. [NAME] 2008
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 879100d1726563348-auto-number-generate-with-conditions-tps_srno_getdata1709-tpsdas-
Sheet: Return

 |  |  |  | 2024-01-01 00:00:00 | to | 2024-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  | IF(AND(B2="delivered", C2<>""), "Closed", "")
STATEMENT OF MATERIALS RETURNED as on
Sl. No. | Deno | COLOUR No. |  |  | Machine No. | Date of Returned
1 |  |  |  |  |  | 17.08.2024 |  |  |  | IF(ROWS('Plate DEntry'!$S$6:$S6)>I$1,"",INDEX('Plate DEntry'!D:D,SMALL(IF(tbl_Data[Return Dt]>=$E$1,ROW(tbl_Data[Return Dt])),ROWS($S$6:S6))))
2 |  |  |  |  |  | 17.08.2024
3 |  |  |  |  |  | 17.08.2024
4 |  |  |  |  |  | 17.08.2024
5 |  |  |  |  |  | 17.08.2024
6 |  |  |  |  |  | 17.08.2024 |  |  | Requirement : In [NAME] :  From DEntry sheet data to come with two or more conditions
7 |  |  |  |  |  | 17.08.2024 |  |  | Presently the conditions are to get data ( in Col D) and the conditions are from date ( E1) to date (G1)
8 |  |  |  |  |  | 17.08.2024 |  |  | Also requested to show where the 3rd condition to apply when there are some requirements
 |  |  |  |  |  |  |  |  | I have tried, but failed
Spreadsheet: 47915d1247086374-invoice-sheet-need-a-formula-to-add-total-invoices-up-based-on-supplier-codes-please-summary
Sheet: SOC Budgets

SOC | soc2 | soc3 | soc 4
SOC Expenditure
Pay Costs | [NAME] | 2 3 | 4
Management | help | 2 | 3
F/T Lecturers
P/T Lecturers
Instructors
Learning Support
Assessors
Business Support
Apprentice
Hr Provision
Inter Company
[NAME]
It Equipment
Other Equipment
Furniture & Fittings
Property
Vehicles
Printing & Stationery
Schools Consumables
European & Domestic Funds
Catering & Retail
Professional Services
Travel & Subsistence - Accom
Travel & Subsistence - Other
Marketing
Exams
Other
Franchise Expenditure / Subcontractor
Access Fund/Student Support
Direct Client & Student Exps
He Validation Costs
Staff Development
Depreciation
Amortisation
Interest & Charges
Contracts
Default Purchases
Inter Company
Spreadsheet: 12b40a0c-a6c4-474b-9a1f-ff0e302481d2
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
 | 8731.0 Building Approvals, Australia
 | TABLE 82. Value of Building Approved, Chain Volume Measures, Original - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total houses ;  New ; |  |  | Original | A590547W | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total other residential building ;  New ; |  |  | Original | A590548X | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A590549A | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590550K | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590551L | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590552R | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590553T | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 46140d1245038545-solved-cant-get-sumproduct-formula-to-work-sumproduct-problem
Sheet: 6. Review category for trans

Journal Entry | Series | [NAME] | Account Number | Account Description | Debit Amount | Credit Amount | Originating Master Name | Originating Master ID | Value | Week | Category | Category |  | Reference
 | Testing | 2009-06-10 00:00:00 | 00-5500-01 | Bank Current Account - MAYBANK (MYR) | 100000 |  | [NAME] Berhad | B003 |  | 24 | CSH2000
Spreadsheet: 90091d1289845819-find-top-5-most-popular-test
Sheet: Month 2

 |  |  |  | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mrs. [NAME] | Total taught
 |  |  | Maths1 | 81 | 24
 |  |  | Maths2 | 52 | 25
 |  |  | Maths3 | 65
 |  |  | English1 | 99
 |  |  | English2 | 87
 |  |  | English3 | 72
 |  |  | Science1 |  | 62
 |  |  | Science2 |  | 57
 |  |  | Science3 |  |  | 13
 |  |  | History1 |  |  | 16
 |  |  | History2 |  |  |  | 47
 |  |  | History3 |  |  |  | 14
Spreadsheet: 770188d1645883399-no-filter-if-field-empty-test-sort
Sheet: MAIN

 |  | BUILD YOUR TRAILER
 |  | ALL | 1
 |  | TYPE | REMORQUE FERMÉE
 |  | DIMENSION | 6x12
 |  | HAUTEUR | 6
 |  | CAPACITÉ | 3500 - 1 essieu
 |  | COULEUR | NOIR
 |  | AVAILABLE INVENTORY
 |  | TYPE | DIMENSION | HAUTEUR | CAPACITÉ | COULEUR | ALL
Spreadsheet: 58f87005-2f36-43e1-a995-019f102d9f15
Sheet: 12's

12 UNDER
TEAM | Championships | Tourny's | Overall | Overall | Overall |  | Bracket | Bracket
2012-05-13 00:00:00 | Won | played | Win | Loss | Ties |  | Won | Lost
Bartow Intimidators |  | 1 | 2 | 3 |  |  | 1 | 1
Christina Flames - Dennis | 1 | 1 | 6 | 3 |  |  | 3 | 1
Diamonds FP | 1 | 1 | 6 | 0 |  |  | 2 | 0
Fishhawk All Stars |  | 1 | 1 | 3 |  |  | 0 | 1
Florida Gold 01 |  | 2 | 2 | 7 |  |  | 5 | 3
Florida Red Rage |  | 1 | 2 | 2 |  |  | 0 | 1
Florida Scorpions |  | 1 | 0 | 4 |  |  | 4 | 2
[NAME] |  | 2 | 7 | 6 |  |  | 3 | 3
Lakeland Rebels |  | 1 | 0 | 4 |  |  | 0 | 1
Makos 01 |  | 1 | 5 | 3 |  |  | 1 | 2
Pinellas Warriors |  | 1 | 2 | 0 |  |  | 0 | 2
Saftey Harbor Stone Crabs 01 |  | 1 | 3 | 3 |  |  | 0 | 2
[NAME] 12U |  | 1 | 1 | 5
Spring Hill Sting |  | 1 | 0 | 2
[NAME] LLC |  | 1 | 1 | 2 |  |  | 0 | 1
Spreadsheet: 85501d1285611000-using-weekly-data-to-convert-to-monthly-quote-analyser
Sheet: 23-08-10

Job # | Quote Value | Sector | Description | Job Won | Sectors | Job Won |  | Building |  |  |  |  |  | Landscaping
1 | 6110 | Building | 31 [NAME], Heaton Moor | No | Building | Yes
2 | 12525.5 | Building | 232 Broadstone Rd, Heaton Chapel | Yes | Landscaping | No
3 | 470 | Building | 8 Whitehall Road, Didsbury | No
4 | 12161.25 | Landscaping | 13 Crosby Street, [NAME] | No
Spreadsheet: 62618d1263532698-logical-values-help-required-query
Sheet: Sheet1

Percentage | Weightage | Data 1 | Month 1 | Data 2 | Month 2 | Data 3 | Month 3 | Data 4 | Month 4 | Data 5 | Month 5 | Data 6 | Month 6 | Total | Output
0.1 | 0.3 | 1
This spreadsheet has Data columns and Month Columns
Data columns has conditional formatting
Value to input is 1 data
Help Required
If I enter 1 in any of the data column then it should do the calculation for consecutive month as below
Example If 1 enter 1 in Data 1 column then it should perform the action for Month 1 as =C2*b2*a2 and display the result 3%
Once the calculation is done then all the other data columns should become 0 and the consecutive months should become 0
The same Data column value and month column value has to be displayed in Total and output columns
Total column is for Data and output column is for Month values
Condition is I may enter 1 in any of the data column then all the data columns and month columns should become 0
Spreadsheet: 766735d1644021279-trying-to-lookup-a-name-and-then-display-total-number-exampleformula
Sheet: Sheet2

Name
appname1 | 1
appname2 | 1
appname4 | 0
appname3 | 0
appname2 | 1
appname4 | 1
appname2 | 0
appname4 | 0
appname3 | 0
appname2 | 1
appname2 | 1
appname4 | 1
appname3 | 1
appname2 | 0
appname4 | 1
appname2 | 0
Spreadsheet: 150981d1334751296-is-there-a-way-to-do-multiple-queries-based-off-of-one-reference-point-simple-schedual-keeper
Sheet: Sheet1

Today
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic1 |  |  | Topic2 |  |  | Topic3 |  |  |  |  |  |  |  |  |  |  |  | Put all Topics Here
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TD | TW | NW | NM | RY |  |  | Today | ThisWeek | NextWeek | w/in 30D | 30+
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-31 00:00:00
Due This Week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic4 |  |  | Topic5
Due Next Week
Due In a Month
Due Later
Spreadsheet: 106453d1303745665-sumifs-across-sheets-copy-of-central-office-2010-2011-w-formulas
Sheet: IS

FIRST NAME | MI | EMP # | CLASSIFICATION | FACILITY | UNIT/COTTAGE | REG FEE | TITLE OF TRAINING | SPONSOR | CITY | STATE | START DATE | END DATE | HOURS | PAS | EVAL | COMMENTS |  | Employee Numbers
Jeanette |  | 424683 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 424683
Antania |  | 646058 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 646058
[NAME] |  | 495042 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 495042
[NAME] |  | 71949 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71949
[NAME] |  | 439185 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 439185
[NAME] |  | 608039 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 608039
[NAME] |  | 462816 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 462816
Arleathia |  | 25374 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25374
[NAME] |  | 72385 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72385
Meri |  | 544272 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 544272
[NAME] |  | 647210 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 647210
[NAME] |  | 608513 |  |  |  |  | Limited English Proficiency | BJJS | Loysville | PA | 2010-11-24 00:00:00 | 2010-11-24 00:00:00 | 3 | 2010-12-10 00:00:00 |  |  |  | 608513
[NAME] |  | 438766 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 438766
[NAME] |  | 494815 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 494815
[NAME] |  | 71810 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71810
[NAME] |  | 525136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 525136
[NAME] |  | 45967 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45967
[NAME] |  | 56717 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56717
Daryl |  | 515249 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 515249
Michelle |  | 49776 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49776
George |  | 489089 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 489089
Avery |  | 628970 |  |  |  |  | Limited English Proficiency | BJJS | Loysville | PA | 2010-11-24 00:00:00 | 2010-11-24 00:00:00 | 3 | 2010-12-10 00:00:00 |  |  |  | 628970
[NAME] |  | 432011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 432011
[NAME] |  | 392020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 392020
Becky |  | 620673 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 620673
[NAME] |  | 87575 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87575
[NAME] |  | 194488 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 194488
[NAME] |  | 35716 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35716
[NAME] |  | 679339 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 679339
[NAME] |  | 515575 |  |  |  |  | Thinking for a Change | BJJS | NCSTU | PA | 2010-09-01 00:00:00 | 2010-09-03 00:00:00 | 21 |  |  |  |  | 515575
[NAME] |  | 455242 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 455242
Spreadsheet: 65064d1265822718-interest-formula-test
Sheet: Sheet1

Year | Months Carried | Cost | Interest
10 | 1 | 38.08 | 3.646918446024471
10 | 2 | 19.04 | 1.728271312828437
10 | 3 | 38.08 | 3.267035380164461
10 | 4 | 19.04 | 1.539196373370946
10 | 5 | 38.08 | 2.890610780663846
10 | 6 | 19.04 | 1.351842777601249
10 | 7 | 38.08 | 2.517613161545418
10 | 8 | 19.04 | 1.166194854356906
11 | 9 | 111.52 | 6.290604590194903
11 | 10 | 92.48 | 4.770865793567138
11 | 11 | 68 | 3.181739912826363
11 | 12 | 68 | 2.856978760175553
11 | 13 | 60.384 | 2.249924982864429
11 | 14 | 79.42399999999999 | 2.583493111511038
11 | 15 | 24.48 | 0.6809610519229593
11 | 16 | 24.48 | 0.5661661238552884
11 | 17 | 24.48 | 0.4518949387194882
11 | 18 | 24.48 | 0.3381451069791679
11 | 19 | 24.48 | 0.2249142500000014
11 | 20 | 39.712 | 0.1820133333333353
 | 21 | 870.4000000000001 | 42.48538504250541
Spreadsheet: 12456116-22d9-4982-a564-33c60825f972
Sheet: Travel Reimbursement

 |  |  |  |  | Name
TRAVEL REIMBURSEMENT REQUEST |  |  |  |  | ID/SSN
FY 2014 |  |  |  |  | Street Address
Return to Accounts Payable for Processing |  |  |  |  | City/State/Zip
 |  |  |  | 0.565 | Travel Start Date
 |  |  |  |  | Travel End Date
EXPENSE TYPE |  | EXPENSE AMOUNT | SPLIT PERCENT | BUDGET NUMBER | BUDGET NUMBER
Auto Mileage | K08 |  |  |  |  | ENTER MILES DRIVEN >>>>>>>>>>>>>>>
Per Diem | G50 |  |  |  |  | Click on per diem tab below
Itemized Meals | G58 |  |  |  |  | Attach Receipts
Lodging | I70 |  |  |  |  | Attach Receipts
Auto Rental | E41 |  |  |  |  | Attach Receipts
Conference Registration | I82 |  |  |  |  | Attach Receipts
Airfare | K10 |  |  |  |  | Attach Receipts
Parking/Tolls/Gasoline | K11 |  |  |  |  | Attach Receipts for any transaction over $25
Taxi/Train/Bus | E46 |  |  |  |  | Attach Receipts for any transaction over $75
Other | K99 |  |  |  |  | Attach Receipts
SUBTOTAL |  |  |  |  |  | BUSINESS PURPOSE OF TRAVEL:
LESS ADVANCE | K09
TOTAL |  |  |  |  |  | DATES OF TRAVEL:
 |  |  |  |  |  | DEPARTURE ADDRESS:
SUPERVISOR SIGNATURE REQUIRED IF OVER $100
 |  |  |  |  |  | RETURN DESTINATION ADDRESS:
PAYEE SIGNATURE
BUDGET OFFICER SIGNATURE
Spreadsheet: 68562d1269099941-excel-2007-pivot-table-with-conditional-value-ranges-forum-4
Sheet: Sheet1

question | property | response 1 | response 2 | response 3 |  |  | question no | user defined value
1 | X | 1 | 3 | 5 |  |  | 4 | 3
2 | Y | 5 | 1 | 6 |  | number below 5 | 3 | 1 | number below  user defined
3 | X | 5 | 4 | 6
4 | Z | 4 | 2 | 1
N | Z | 3 | 2 | 5
Spreadsheet: 819901d1677758887-formula-to-tell-cell-which-cell-to-read-excel-workbook-rhinolite-calcs
Sheet: Sheet1

 |  | RHINOLITE calcs
 |  |  |  | [NAME] gets a value from another [NAME] of a value between 2 and 15. I need G10 to see what the value of C3 is, and then decide which cell to use that is similar or close to the values in the B Cells. However, it need to then add the values of either [NAME] or [NAME]. |  |  |  |  |  | TOTAL AREA |  | 300 | M2
 | 3MM THICKNESS |  |  |  | per BAG | [NAME] | ROUNDED | TOTAL PRICE
 | 3 | 25 |  |  | 20 | 27.2
 | 5-6MM THICKNESS |  |  |  |  |  | Tot lab
 | 5 | 11.5 |  | labour/m2 | 50 | 10
 |  |  |  |  | /m2 | m2/BAG
 | 12-15MM THICKNESS
 | 12 | 4.5 |  |  |  |  |  |  |  | 0.08 | wastage
 |  |  |  |  |  |  |  |  |  | sub total 01
 | 15-20MM THICKNESS |  |  |  |  |  |  |  | 0 | 0.04 | prelims
 | 15 | 3 |  |  |  |  |  |  |  | sub total 2
 |  | for your information, the 3,5,12,15 resembles the thickness you apply the plaster, and due to variuos thickness, the areas 25;11.5;4.5;3 shows the area you get per bag of Rhinolite when you apply various thickness. G10 Need to add the specific area to calculate the amount of bags to be used |  |  |  |  |  |  |  | 0.05 | profit
 |  |  |  |  |  |  |  |  |  | total price per m²