tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 583226d1532331569-dependent-drop-down-or-vlook-ups-to-be-used-for-multiples-data-interconnected-naroda-project-costing
Sheet: BOX OFFICE

PROJECT COSTING FOR MATERIAL RELATED TO BOX OFFICE
SR NO | ITEMS DESCRIPTION | QTY REQD |  | VENDOR | SIZE | SPECIFICATION | RATE PER SQ.FT | COST PER PIECE | GUARANTEE / WARRANTY | PERIOD FOR GUARANTEE / WARRANTY | AMOUNT | GST % | GST AMOUNT | TOTAL COST
1 | NOTICE BOARD | 1 | TOUGHENED GLASS | TOUGHENED GLASS |  |  |  |  |  |  |  | 0.18
 | FRONT TOUGHENED GLASSS FOR BOX OFFICE
 | POSTER BOX FOR THE DISPLAY OF WEEKLY SCREENING SCHEDULE | 2
 | BOX OFFICE NEON OUTSIDE THE BOX OFFICE | 1 |  |  |  |  |  | 80000
 | BRAND LOGO NEON INSIDE THE BOX OFFICE ON THE WALL BEHIND THE EXECUTIVE | 1
 | POS WITH CPU | 0 |  |  |  |  |  | 30000 |  |  |  | 0.18
 | KEYBOARD | 2
 | [NAME] | 2
 | [NAME] | 2
 | UPS (03 KVA - 230 V) ONLINE FOR POS/COMPUTER | 0 |  |  |  |  |  | 28000
 | PRINTERS | 0 |  | KEPLERTECH |  |  |  | 10000
 | Q-MANAGERS OUTSIDE THE BOX OFFICE FOR PATRONS | 10
 | LED T.V FOR DISPLAY | 2 |  |  |  |  |  | 16000
 | MIKE WITH SPEAKERS | 2 |  |  |  |  |  | 7000
 | ACCESS CONTROL SYSTEM | 1
 | AIR FRESHNER MACHINE | 1
 | CHAIRS | 2 |  |  |  |  |  | 2000
 | COUNTER FURNITURE
 | FAKE NOTE DETECTOR MACHINE | 1 |  | METHODEX |  |  |  | 1500
 | 02 NOS OF LED LIGHT OUTSIDE THE BOX OFFICE | 2
 | 04 - 06 NOS OF LED LIGHT INSIDE THE BOX OFFICE | 4
 | 02 - 03 CAMERAS WITH SOUND FACING THE CROWD STANDING IN THE QUE | 2
 | 02 - 03 CAMERAS WITH SOUND FACING THE POS & TRANSACTION | 2
 | FIRE EXTINGUISHER (ACB TYPE) (05 KG) | 1
 | A/4 SIZE ACRYLIC STAND FOR COMMUNICATION | 3 |  |  |  |  |  | 150
 | SMALL DUSTBIN | 2 |  |  |  |  |  | 350
 | MAIN DOOR OF BOX OFFICE | 1
 | HANDLE FOR MAIN DOOR AT BOX OFFICE | 2
 | LOCK AT MAIN DOOR FOR BOX OFFICE | 1
 | FALL CEILING POP WORK AT BOX OFFICE
 | PAINTING AT BOX OFFICE
TOTAL COST OF EXPENSES FOR THE NEW PROJECT
Spreadsheet: 826714d1682190384-confused-using-countif-s-across-multiple-worksheets-with-drop-down-menus-fy-23-icass-count-2023-2024-
Sheet: Jul 23

Inbound |  |  |  |  |  | Outbound
Date | Office | Owner (if personal) | Content/Service | Agency/Icass Code | Reference #/ Description | Date2 | office2 | Owner (if personal)2 | Content/Service2 | Agency/Icass Code2 | Reference # / Description
1906-01-30 00:00:00 |  |  |  | 1150.0 DSCA - Defense Security Cooperation Agency
1960-11-02 00:00:00 |  |  |  | 1525  DOJ - FBI - LEGATT, [NAME]
1991-04-05 00:00:00 |  |  |  | 1330.0 DOC - ITA - Global Markets
1909-02-14 00:00:00 |  |  |  | 1150.0 DSCA - Defense Security Cooperation Agency
8313-02-10 00:00:00 |  |  |  | 1150 DSCA - Defense Security Cooperation Agency
8313-02-11 00:00:00 |  |  |  | 1150 DSCA - Defense Security Cooperation Agency
Spreadsheet: 736882d1623933592-match-data-from-multiple-sheet-test
Sheet: Sheet2

 | APPLE | AA | 1
 | KIWI | BB | 2
 | APPLE | CC | 3
 | ORANGE | DD | 4
 | KIWI | EE | 5
 | WATERMELON | FF | 6
 | PEAR | GG | 7
 | ORANGE | HH | 8
 | STARFRUIT | II | 9
 | MANGO | AA | 10
 | MELON | DD | 11
 | GRAPE | JJ | 12
Spreadsheet: 09f25393-4ba5-4d3d-9616-15ba2dd06203
Sheet: Sheet1

Cheese mold dimensions and volumes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | (Boofer - March 23, 2012) | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | width | height | volume |  | volume |  | volume |  | volume |  | depth
 |  | inches | inches | [NAME] |  | [NAME] |  | [NAME] (32oz) |  | gallons (128oz) |  | inches
Small Tomme |  | 5.375 | 2.25 | 51.02806640625001 |  | 28.27529220204879 |  | 0.8836028813140248 |  | 0.2209007203285062 |  | ------------
Typical Tomme |  | 7.375 | 3.5 | 149.4382421875 |  | 82.80560604378618 |  | 2.587675188868318 |  | 0.6469187972170796 |  | ------------
Large Tomme |  | 7.875 | 5.75 | 279.92302734375 |  | 155.1088636048572 |  | 4.847151987651786 |  | 1.211787996912947 |  | ------------
[NAME] |  | 4.25 | 4.25 | 60.26101562500001 |  | 33.39138527460266 |  | 1.043480789831333 |  | 0.2608701974578333 |  | ------------
Small Kadova * |  | 4.75 | 2.5 | 44.27890625000001 |  | 24.53549783051407 |  | 0.7667343072035646 |  | 0.1916835768008912 |  | ------------
[NAME] |  | 3.5 | 6 | 57.6975 |  | 31.970909084415 |  | 0.9990909088879688 |  | 0.2497727272219922 |  | ------------
Large Bûcheron |  | 4.625 | 7.5 | 125.9373046875 |  | 69.78344154426681 |  | 2.180732548258338 |  | 0.5451831370645844 |  | ------------
Swiss, Cheddar (microperf) |  | 6.25 | 6 | 183.984375 |  | 101.9480519273438 |  | 3.185876622729492 |  | 0.7964691556823731 |  | ------------
Brick |  | 10 | 5.5 | 268.125 |  | 148.57142854125 |  | 4.642857141914063 |  | 1.160714285478516 |  | 4.875
 |  | width | height | volume |  | volume |  | depth
 |  | cm | cm | [NAME] |  | liter |  | cm
Small Tomme |  | 13.6525 | 5.715 | 836.2001899954688 |  | 0.8362001899954689 |  | ------------
Typical Tomme |  | 18.7325 | 8.89 | 2448.854038774063 |  | 2.448854038774063 |  | ------------
Large Tomme |  | 20.0025 | 14.605 | 4587.116564155782 |  | 4.587116564155782 |  | ------------
[NAME] |  | 10.795 | 10.795 | 987.5011197518752 |  | 0.9875011197518752 |  | ------------
Small Kadova * |  | 12.065 | 6.35 | 725.60127056875 |  | 0.72560127056875 |  | ------------
[NAME] |  | 8.89 | 15.24 | 945.4926251400002 |  | 0.9454926251400002 |  | ------------
Large Bûcheron |  | 11.7475 | 19.05 | 2063.742671901563 |  | 2.063742671901563 |  | ------------
Swiss, Cheddar (microperf) |  | 15.875 | 15.24 | 3014.963728125 |  | 3.014963728125 |  | ------------
Brick |  | 25.4 | 13.97 | 4393.781535 |  | 4.393781535 |  | 12.3825
One in3 = | 0.554112554 | [NAME]
volume = [NAME] |  | <height x 3.14 x radius2>
231 cubic inches in a gallon (128 oz)
1 cubic inch = 0.554112554 ounces [Fluid, US]
One inch = 2.54 cm
One cm3 = | ml
* Note = mold has rounded bottom so this is an estimate only.
Spreadsheet: 136907d1326883400-please-help-making-specific-chart-waterfalleffectchart
Sheet: Sheet1

 |  | ASP | shipmentCost | warehousingCose | [NAME] | OPEX | netASP |  | MARIO
 | Mario | 0.91 | 0.15 | 0.0004 | 0.5 | 0.05
 | Luigi | 0.9 | 0.17625 | 0.0004 | 0.5 | 0.05 |  |  |  | 0.9
 | KingKong | 0.92 | 0.0415 | 0.0004 | 0.5 | 0.05 |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0.76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
 |  |  |  |  |  |  |  |  |  | ASP |  | shipmentCost |  | warehousingCost |  | Cogs |  | Opex |  | netASP
Spreadsheet: 186401d1350028985-how-to-show-info-from-main-sheet-to-a-a-new-sheet-0a1_fot_1tapes-test
Sheet: Sheet2

Tape # | Container # | [NAME]. # | Date out | Date to be back |  |  | Tape #here |  | AAG684
Spreadsheet: 845873d1697194847-auto-generate-group-number-and-reference-back-to-previous-grouping-number-book1-219-aligw
Sheet: Sheet1

 |  |  |  | [NAME] | Grouping
 |  |  |  | BPR59715
 |  |  |  | BPR31607
 |  |  |  | BPR32267
 |  |  |  | BPR82594
 |  |  |  | BPR64995
 |  |  |  | BPR95261
 |  |  |  | BPR55820
 |  |  |  | [NAME]
 |  |  |  | BPR40132
 |  |  |  | BPR40975
 |  |  |  | BPR56524
 |  |  |  | BPR32267
 |  |  |  | BPR82594 |  |  |  | If Countif =1, then Group +1, else refer back to previous
 |  |  |  | BPR40975
 |  |  |  | BPR11111
 |  |  |  | BPR11112
 |  |  |  | BPR11113
 |  |  |  | BPR11114
 |  |  |  | BPR11115
 |  |  |  | BPR11111
Spreadsheet: 103077d1300904448-countif-given-numerous-conditions-or-use-macro-attendanceandsafetymonitor1
Sheet: Total

 | Date
From | 2011-01-01 00:00:00
To | 2011-03-22 00:00:00
 |  | No of days
P | Present
WE | Weekend
WH | Works Holiday
H | Holiday
A | Absent
L | Lost time
F | First Aid
N | Near miss
TC | Training Course
Spreadsheet: 96378d1295794949-2d-lookup-and-return-sum-values-sumproduct
Sheet: Output

 |  |  | 2010-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00
 |  |  |  |  |  |  |  | Key1 | Month | Month Text | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00
 |  |  |  |  |  |  |  | 12 | 2009-12-01 00:00:00 | Dec-09 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00
 |  |  |  |  |  |  |  | 11 | 2010-01-01 00:00:00 | Jan-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00
 |  |  |  |  |  |  |  | 10 | 2010-02-01 00:00:00 | Feb-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00
 |  |  |  |  |  |  |  | 9 | 2010-03-01 00:00:00 | Mar-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00
 |  |  |  |  |  |  |  | 8 | 2010-04-01 00:00:00 | Apr-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  | 7 | 2010-05-01 00:00:00 | May-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  | 6 | 2010-06-01 00:00:00 | Jun-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  | 5 | 2010-07-01 00:00:00 | Jul-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  |  |  |  |  |  | 4 | 2010-08-01 00:00:00 | Aug-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  |  |  |  |  |  | 3 | 2010-09-01 00:00:00 | Sep-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 |  |  |  |  |  |  |  | 2 | 2010-10-01 00:00:00 | Oct-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 |  |  |  |  |  |  |  | 1 | 2010-11-01 00:00:00 | Nov-10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-01 00:00:00
Spreadsheet: eefcc081-f27f-47a9-b8e2-043b1627a8ee
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193153821 | [NAME] | Morning, The | 2013-08-27 | Compact Disc | Gospel | 10.99 | Y | Available
Spreadsheet: 853653d1703578270-make-formula-dynamic-dropdown-list-showing-blanks-dropdown_sample_alphabet
Sheet: D

Cond | Values
 | Account Executive
 | [NAME]
 | Chief Financial Officer
 | Director Of Inside Sales
 | Go
 | IT Professional
Spreadsheet: 788567d1658543085-sumifs-for-ltm-revenue-over-unique-customer-book1
Sheet: Sheet1

 | Start Date to Calculate LTM I |  |  |  | 2022-07-01 00:00:00
 | Customer Name |  | Date of Invoice |  | Invoice Amount
 | A |  | 2022-07-01 00:00:00 |  | 56940
 | A |  | 2022-05-25 00:00:00 |  | 88308
 | A |  | 2022-01-13 00:00:00 |  | 11281
 | A |  | 2021-12-01 00:00:00 |  | 82792
 | A |  | 2021-04-01 00:00:00 |  | 25754
 | B |  | 2022-06-01 00:00:00 |  | 49712
 | B |  | 2022-03-03 00:00:00 |  | 13773
 | B |  | 2022-01-01 00:00:00 |  | 85304
 | B |  | 2021-11-01 00:00:00 |  | 64792
 | B |  | 2020-09-01 00:00:00 |  | 35244
 | C |  | 2022-05-01 00:00:00 |  | 65427
 | C |  | 2022-02-15 00:00:00 |  | 64392
 | C |  | 2021-12-15 00:00:00 |  | 60092
 | C |  | 2021-01-01 00:00:00 |  | 54986
 | C |  | 2020-11-20 00:00:00 |  | 23267
 | A
 | B
 | C
Spreadsheet: 145210d1331379124-sum-if-function-from-different-cells-example
Sheet: Data

Product | Pages | Machine | Production Start | Productivity
asd | 4 | A | 07:00:00 | 5000
[NAME] | 6 | B | 08:00:00 | 5666
fjgj | 8 | A | 08:05:00 | 3444
ksdhfk | 4 | A | 15:00:00 | 7888
dfhdnfg | 6 | A | 15:15:00 | 9664
[NAME] | 7 | C | 23:15:00 | 4567
hdjash | 9 | C | 23:30:00 | 8976
ytir | 2 | B | 1900-01-01 00:00:00 | 3457
[NAME] | 8 | C | 00:45:00 | 5643
hasjf | 4 | C | 03:00:00 | 1234
sdf | 6 | A | 05:00:00 | 6543
[NAME] | 7 | B | 02:15:00 | 7653
tyue | 9 | C | 04:15:00 | 8754
jjjs | 2 | B | 23:00:00 | 5567
jjs | 8 | A | 18:15:00 | 8890
kkkd | 4 | A | 1900-01-01 00:00:00 | 7659
jjje | 6 | B | 00:45:00 | 9876
jjjja | 7 | C | 03:00:00 | 3453
jjjjsd | 9 | C | 05:00:00 | 2357
jjjed | 2 | B | 02:15:00 | 8754
Spreadsheet: 290861d1389991543-need-help-to-split-buy-and-sell-from-live-feed-mutant
Sheet: Sheet1

 | LIVE FEED FROM SOURCE
 | Last 10 Fills |  |  |  |  | Last 10 Fills |  |  |  | Last 10 Fills
 | BUY/SELL | Qty | Price |  |  | BUY | Qty | Price |  | SELL | Qty | Price
 | B | 5 | 290
 | S | 4 | 170
 | S | 3 | 280
 | B | 2 | 220 | Split  to | >>
 | B | 3 | 160 |  |  | B | 5 | 290
 | S | 2 | 250 |  |  | B | 2 | 220
 | B | 4 | 180 |  |  | B | 3 | 160 |  | S | 4 | 170
 | B | 5 | 300 |  |  | B | 4 | 180 |  | S | 3 | 280
 | B | 6 | 150 |  |  | B | 5 | 300 |  | S | 2 | 250
 | S | 1 | 200 |  |  | B | 6 | 150 |  | S | 1 | 200
 | when new data feed in eg:
 | Last 10 Fills |  |  |  |  | Last 10 Fills |  |  |  | Last 10 Fills
 | BUY/SELL | Qty | Price |  |  | BUY | Qty | Price |  | SELL | Qty | Price
oldest feed | S | 4 | 170
 | S | 3 | 280
 | B | 2 | 220
 | B | 3 | 160
 | S | 2 | 250 |  |  | B | 5 | 290
 | B | 4 | 180 |  |  | B | 2 | 220 |  | S | 4 | 170
 | B | 5 | 300 |  |  | B | 3 | 160 |  | S | 3 | 280
 | B | 6 | 150 |  |  | B | 4 | 180 |  | S | 2 | 250
 | S | 1 | 200 |  |  | B | 5 | 300 |  | S | 1 | 200
latest feed | S | 2 | 210 |  |  | B | 6 | 150 |  | S | 2 | 210
Spreadsheet: 003fdd0d-c64a-4805-9564-a2cd5f9d1613
Sheet: Disability codes

n/a | n/a | SFY 2014 FEDERAL CODE SHEET
SFY 2014 FEDERAL EDRS-SERVS-UFARS codes crosswalk
n/a | n/a | n/a
UFARS Program Code to EDRS Disability Code
UFARS PROGRAM CODE | EDRS DISABILITY CODE | [NAME]
401 | 401 | Speech or Language Impairments
402 | 402 | Developmental Cognitive Disability - Mild -Moderate
403 | 403 | Developmental Cognitive Disability - Severe-Profound
404 | 404 | Physically Impaired
405 | 405 | Deaf and Hard of Hearing
406 | 406 | Visually Impaired
407 | 407 | Specific Learning Disability
408 | 408 | Emotional or Behavioral Disorders
409 | 409 | Deaf-Blind
410 | 410 | Other Health Disabilities
411 | 411 | Autism Spectrum Disorders
412 | 412 | Developmentally Delayed
414 | 414 | Traumatic Brian Injury
416 | 416 | Severely Multiply Impaired
420 | 420 | Special Education - Aggregate (3 or more Disabilities)
422 | 422 | Non-Disabled (no IEP/IFSP/IIIP) (use FSC Z CEIS and FSC z MCEIS only)
end of worksheet
Spreadsheet: 126607d1319772938-excel-2007-how-to-populate-a-cell-via-various-selections-from-two-other-cells-transport-control-sheet
Sheet: Transport Bookings October 2011

Date | COMPANY | Eq | Job No: | Customer Reference | Trip Type | Pick Up | Driver | [NAME] | Rate | [NAME] | Fuel | Sub Total | GST | Total | Paperwork complete
2011-10-24 00:00:00 | Transport1 |  |  |  |  | Melbourne to Sydney | GLENN | VV80IH
2011-10-24 00:00:00 | Transport1 | BD | 24O112 |  | DIRECT | Melbourne to Sydney | ANDY | YGH408
2011-10-24 00:00:00 | Transport1 | BD | 24O113 |  | DIRECT | Melbourne to Sydney | CLARKE | VV08IR
2011-10-24 00:00:00 | Transport1 | BD | 24O114 |  | DIRECT | Melbourne to Sydney | ALAISTAIR | VV95IT
2011-10-24 00:00:00 | Transport1 | BD | 24O115 |  | DIRECT | Melbourne to Sydney
 | Transport1 |  |  |  |  | Melbourne to Sydney
2011-10-24 00:00:00 | Transport1 |  |  |  |  | Melbourne to Adelaide
2011-10-24 00:00:00 | Transport2 |  |  |  |  | Melbourne to Adelaide
 |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: b5bcce4a-933e-434d-93a8-d8bdf2ec9d30
Sheet: Sheet1

12 | DL580 G4 spec | [NAME] cost | DL585 G2 spec | DL585 G2 cost | DL360 G5 spec | DL360 G5 cost
Purchase price of hardware -1 | 22300 | 22300 | 27443/36200 |  | 5800 | 5800
Support contract -2 | 0 | 0 | 0 | 0 | 950 | 950
OS license cost -3 | 2600 |  | 2600 |  | 800 | 800
VMWare license | 14000 | 14000 | 14000 | 14000 | 0 | 0
UPS fraction -4 | 0.9 | 900 | 0.8 | 800 | 0.4 | 400
Generator fraction -5 | 0.9 | 270 | 0.8 | 240 | 0.4 | 120
AC fraction -6 | 0.25 |  | 0.25 |  | 0.1
3 year power including AC -7 | 38320 | 3832 | 25200 | 2520 | 12600 | 1260
manpower for OS rebuild upon server replacement -8 | 0 | 0 | 0 | 0 | 4 | 250
Toal per machine
Systems required for solution and total cost
Notes
1)Price for hardware only
2)No support beyond basic support needed beyond basic hardware contract for VMWare because systems can be dynamically moved and restarted on good hardware
3)One 2003 Enterprise license needed per 4 virtual machines of one 2003 Standard per 360 G5
4)UPS purchase price of $50K for 50kvA averaged over system kvA used, power figures are in kvA and are based on HP numbers for systems at 70% utilization
5)Generator price of $30K for 100kvA averaged over system kvA used
6)
7)3 year killowatt hour total at 70% utilization price factors average price per killowatt hour of $0.10
8)4 hours to build a system mutliplied by a conservative cost of $60/hour for systems administrator time including overhead costs
Spreadsheet: 793740d1661682925-multiple-closest-matches-with-multiple-criteria-book1
Sheet: Summary

Current - With [NAME]
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1
Staff 2
Staff 3
Staff 4
Expected - No formulas
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1 | 10:15:00 | 10:16:00 | 1 | 11 | 12:15:00 | 12:18:00 | 3 | 30 | 14:15:00 | 14:47:00 | 32 | 8
Staff 2 | 11:45:00 | 11:50:00 | 5 | 10 | 14:15:00 | 14:19:00 | 4 | 30 | 15:45:00 | 15:49:00 | 4 | 10
Staff 3 | 10:00:00 | 14:02:00 | - | - | 11:45:00 | 11:47:00 | 2 | 30 | 13:45:00 | 14:02:00 | 17 | 9
Staff 4 | 10:15:00 | 10:16:00 | 1 | 10 | 12:15:00 | 12:23:00 | 8 | 30 | 13:45:00 | 13:46:00 | 1 | 10
Spreadsheet: 536290d1504355398-min-if-function-across-multiple-worksheets-min-if-test-sheet-1-
Sheet: summary

Project | Start |  |  |  |  |  |  |  | 2015
A | 2015-01-01 00:00:00 |  |  |  |  |  |  |  | 2016
B | 2015-01-01 00:00:00 |  |  |  |  |  |  |  | 2017
C | 2015-04-01 00:00:00
D | 2015-02-01 00:00:00
E | 2015-02-01 00:00:00
F | 2016-02-01 00:00:00
Spreadsheet: 48566d1247780594-indirect-mod-row-skipping-a-lot-of-rows-test-f-ms-annual-student-report-template-07-16-09-fs
Sheet: Cover

 |  |  |  |  |  |  |  |  |  |  |  | Date:
Submitted By:
Student Action Plan Goals |  |  |  |  |  |  |  |  |  | Academics
Attendance
 | MS |  |  |  |  | Absent Excused | Absent Unexcused |  |  | Tardy |  |  | Cut Short |  | Probation (Y/N)?
 |  |  |  |  |  |  |  |  |  | <20min |  | >20min | <20min | >20min
 |  | AP1 | Regular Session
 |  |  | Make-Up Session
 |  |  | Support Session
 |  |  | Supplemental Session
 |  | AP2 | Regular Session
 |  |  | Make-Up Session
 |  |  | Support Session
 |  |  | Supplemental Session
 |  | AP3 | Regular Session
 |  |  | Make-Up Session
 |  |  | Support Session
 |  |  | Supplemental Session
Family Involvement |  |  |  |  |  |  |  |  |  | Behavior
 |  |  |  |  |  |  |  |  |  |  | Interventions by Type
Outreach
Detention/Make-up Session Summary
 |  |  |  | Count per attendance period
 |  |  |  | AP 1 | AP2 | AP3
 | Detention  (Assignment Log)
 | Detention(Behavior)
 | Dentention  (Organization)
 | Make-Up (Absence)
 | Make-Up (Supplemental)
 | Make-Up (Consequence)
Spreadsheet: barry_tycholiz__828__Denver Cash Mgmt1
Sheet: 5DAY Pending

Payee | Amount | Description | Date Due | Pre/Post | Justification
Equity Office | 25124.15 | Office Rent | 2001-12-10 00:00:00 | Post Petition | Needed to keep from being evicted
Standard Parking | 405 | Employee parking | 2001-12-01 00:00:00 | Post Petition | Contribution debit from employee pay.
Qwest | 604 | Phone Service | 2001-12-12 00:00:00 | Post Petition | Keep Phones working
Qwest | 3179.73 | Phone Service | 2001-12-16 00:00:00 | Post Petition | Keep Phones working
Spreadsheet: 745c58a8-1601-4f36-9717-4c47e1cd031a
Sheet: Sheet1

Table S2. Group-level probability of testing for HIV within the BED recency period (P) based on the proportion of individuals diagnosed with AIDS at the time of HIV diagnosis (q)
q | P |  | q | P |  | q | P |  | q | P |  | q | P
0.01 | 0.5745 |  | 0.11 | 0.19237 |  | 0.21 | 0.1196 |  | 0.31 | 0.08281 |  | 0.41 | 0.05945
0.02 | 0.45179 |  | 0.12 | 0.18171 |  | 0.22 | 0.11494 |  | 0.32 | 0.08004 |  | 0.42 | 0.05755
0.03 | 0.38267 |  | 0.13 | 0.17213 |  | 0.23 | 0.11055 |  | 0.33 | 0.07737 |  | 0.43 | 0.05571
0.04 | 0.33594 |  | 0.14 | 0.16348 |  | 0.24 | 0.10641 |  | 0.34 | 0.07482 |  | 0.44 | 0.05393
0.05 | 0.30133 |  | 0.15 | 0.1556 |  | 0.25 | 0.1025 |  | 0.35 | 0.07237 |  | 0.45 | 0.05221
0.06 | 0.27423 |  | 0.16 | 0.14838 |  | 0.26 | 0.0988 |  | 0.36 | 0.07001 |  | 0.46 | 0.05054
0.07 | 0.25218 |  | 0.17 | 0.14174 |  | 0.27 | 0.09528 |  | 0.37 | 0.06774 |  | 0.47 | 0.04892
0.08 | 0.23375 |  | 0.18 | 0.1356 |  | 0.28 | 0.09194 |  | 0.38 | 0.06556 |  | 0.48 | 0.04734
0.09 | 0.21802 |  | 0.19 | 0.12989 |  | 0.29 | 0.08875 |  | 0.39 | 0.06345 |  | 0.49 | 0.04581
0.1 | 0.20438 |  | 0.2 | 0.12457 |  | 0.3 | 0.08571 |  | 0.4 | 0.06142 |  | 0.5 | 0.04432