tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827490d1682733300-minif-and-maxif-values-in-range-help-max-min-profit-example
Sheet: Sheet1

year | month | Date | Open | High | Low | Close | Volume | volatility | 9 EMA | crossover | trade signal | [NAME] profit | [NAME] loss
2023 | 3 | 45002 | 24.93 | 25.51 | 24.1 | 24.57 | 201770300 | 0.0565583634175692 | 23.24948121859947 | long | entry/exit
2023 | 3 | 45005 | 24.43 | 24.92 | 23.889999 | 24.83 | 164178000 | 0.04216131805157602 | 23.56558497487958 | long
2023 | 3 | 45006 | 25.309999 | 26 | 24.93 | 25.879999 | 135145100 | 0.04227578199430194 | 24.02846777990366 | long
2023 | 3 | 45007 | 25.709999 | 26.959999 | 24.65 | 24.68 | 237918100 | 0.08984827265065243 | 24.15877422392293 | long
2023 | 3 | 45008 | 25.6 | 26.610001 | 24.879999 | 25.559999 | 196497200 | 0.06757820312499996 | 24.43901917913835 | long
2023 | 3 | 45009 | 25.440001 | 25.84 | 24.84 | 25.82 | 169794700 | 0.03930817455549628 | 24.71521534331067 | long
2023 | 3 | 45012 | 25.99 | 26.26 | 25.059999 | 25.290001 | 136795600 | 0.04617164293959217 | 24.83017247464854 | long
2023 | 3 | 45013 | 25.139999 | 25.139999 | 24.290001 | 24.870001 | 118020700 | 0.03381058209270411 | 24.83813817971883 | long
2023 | 3 | 45014 | 25.76 | 26.370001 | 25.57 | 26.23 | 119365300 | 0.03105593944099371 | 25.11651054377507 | long
2023 | 3 | 45015 | 26.82 | 27.09 | 26.49 | 26.940001 | 130150000 | 0.0223713646532439 | 25.48120863502006 | long
2023 | 3 | 45016 | 27 | 28.32 | 26.91 | 28.26 | 126571300 | 0.05222222222222223 | 26.03696690801605 | long
2023 | 4 | 45019 | 27.68 | 28.120001 | 27.33 | 28.059999 | 125116300 | 0.0285404985549133 | 26.44157332641284 | long
2023 | 4 | 45020 | 28.16 | 28.43 | 27.42 | 27.780001 | 116090400 | 0.0358664772727272 | 26.70925886113028 | long
2023 | 4 | 45021 | 27.469999 | 27.52 | 26.41 | 26.889999 | 129137000 | 0.0404077189809872 | 26.74540688890422 | long
2023 | 4 | 45022 | 26.459999 | 27.559999 | 26.110001 | 27.43 | 120960300 | 0.05479962414208711 | 26.88232551112338 | short | entry/exit
2023 | 4 | 45026 | 26.639999 | 27.379999 | 26.17 | 27.370001 | 118528800 | 0.04542038458785227 | 26.9798606088987 | short
2023 | 4 | 45027 | 27.360001 | 27.370001 | 26.700001 | 26.84 | 104260800 | 0.02448830319852686 | 26.95188848711896 | long | entry/exit
2023 | 4 | 45028 | 27.34 | 27.49 | 26 | 26.129999 | 174019300 | 0.05449890270665685 | 26.78751058969517 | long
2023 | 4 | 45029 | 26.530001 | 27.74 | 26.49 | 27.629999 | 123761500 | 0.04711647014261326 | 26.95600827175614 | short | entry/exit
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 23

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap transaction volumes, week ending January 25, by product type, participant type, and cleared status (in number of transactions), all tenors, currencies, and deliveries. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 843715d1695513198-is-there-a-way-to-force-the-index-function-to-return-cell-references-instead-of-values-test-2b
Sheet: detail

 |  |  |  |  | ROW | INDEX(ROW) | N(INDEX(ROW)) | ADDRESS(N(INDEX(ROW))) | INDEX(ADDRESS(N(INDEX(ROW))))
 | Yardi | -272.1 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | -272.09 | 0101017
 | Yardi | -272.09 | 0101017
 | Yardi | -272.09 | 0101017
 | Yardi | -230 | 0101017
 | Yardi | -224.54 | 0101017
 | Yardi | -191.94 | 0101017
 | Yardi | -173.27 | 0101017
 | Yardi | -139 | 0101017
 | Yardi | -124.8 | 0101017
 | Yardi | -88.3 | 0101017
 | Yardi | -68.62 | 0101017
 | Yardi | -42.83 | 0101017
 | Yardi | -40.31 | 0101017
 | Yardi | -38.88 | 0101017
 | Yardi | -32.39 | 0101017
 | Yardi | -32.1 | 0101017
 | Yardi | -19.61 | 0101017
 | Yardi | -5.77 | 0101017
 | Yardi | -5.2 | 0101017
 | Yardi | 0.02 | 0101017
 | Yardi | 0.02 | 0101017
 | Yardi | 0.03 | 0101017
 | Yardi | 0.06 | 0101017
 | Yardi | 0.07 | 0101017
 | Yardi | 0.08 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | 272.09 | 0101017
 | Yardi | -272.09 | 0101017
Spreadsheet: benjamin_rogers__1179__BasePowerModel3
Sheet: IS

INCOME STATEMENT
('000 $)
Revenue
Fixed Price Period:
Capacity Revenue
Energy Revenue
Variable Energy Revenue |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Block Payment |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Market Period:
Capacity Revenue
Energy Revenue
Variable Energy Revenue |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Block Payment |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Energy Margin
Ancillary Services |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fees |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex |  |  | 410.19 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914 | 844.9914
Insurance
SG&A
Utility Start Power
Property, Other Tax (1) |  |  | 0 | 540.3022988061599 | 529.38710085048 | 518.4719028948 | 507.55670493912 | 496.64150698344 | 485.72630902776 | 469.35351209424 | 452.9807151607199 | 436.6079182272 | 414.77752231584 | 1178.84137921344 | 1096.97739454584 | 998.7406129447199 | 900.5038313436 | 802.2670497424799 | 671.28467427432 | 523.92950187264 | 376.57432947096 | 327.4559386704 | 327.4559386704 | 0
Debt Service Reserve [NAME]
Marketing Fee |  |  | 0 | 0 | 0 | 0
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense (2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 772889d1647513493-help-with-data-analysis-example-tms
Sheet: Sheet1

Person | Team | #courses | #breaks | #hobbies |  |  | 2022-01-01 00:00:00
[NAME] | a | 2 | 1 | 6
April | b | 0 | 0 | 5
Mark | c | 3 | 2 | 0
[NAME] | a | 4 | 0 | 5
[NAME] | b | 0 | 3 | 2
[NAME] | a | 6 | 0 | 0
Spreadsheet: 129133d1321464307-vlookup-over-multiple-sheets-copy-of-2011-barter-and-trade-test
Sheet: December

Customer | Net | [NAME] | Size | Rep
[NAME]'s Bakery | 1 | 1 | 1/3 Page Square | [NAME]
[NAME]'s Flower Market | 2 | 2 | 1/4 Page | [NAME]
Alabama Ballet | 3 | 3 | [NAME] | [NAME]
ESPN Regional Television | 4 | 4 | [NAME] | [NAME]
Al.com | 5 | 5 | 2/3 Page | [NAME]
[NAME] | 6 | 6 | 1/2 Page | [NAME]
[NAME] | 7 | 7 | 1/3 Page Square | [NAME]
Birmingham Mountain Radio | 8 | 8 | [NAME] | [NAME]
Boutwell Studios | 9 | 9 | [NAME] | [NAME]
Cultural Alliance of Greater Birmingham - Birmingham 365 | 10 | 10 | [NAME] | [NAME]
The Birmingham News | 11 | 11 | [NAME] | [NAME]
Best Doctors | 12 | 12 | [NAME] | [NAME]
Spreadsheet: 844614d1696378088-index-match-with-multiple-results-unpivot-table-alternative-solution-
Sheet: Sheet1

Name | Ford | Toyota | Mazda | Lexus | BMW
[NAME] | X |  | X
[NAME] |  |  | X | X | X
[NAME] | X | X
Name | Car |  | HD [NAME] |  |  | ALTERNATIVE SOLUTION
[NAME] | Ford |  |  | Ford |  |  | Ford
[NAME] | Mazda |  | [NAME] | Mazda |  | [NAME] | Mazda
[NAME] | Mazda |  | [NAME] | Mazda |  | [NAME] | Mazda
[NAME] | Lexus |  | [NAME] | Lexus |  | [NAME] | Lexus
[NAME] | BMW |  | [NAME] | BMW |  | [NAME] | BMW
[NAME] | Ford |  | [NAME] | Ford |  | [NAME] | Ford
[NAME] | Toyota |  | [NAME] | Toyota |  | [NAME] | Toyota
Spreadsheet: 161992d1339688997-excel-2007-convert-columns-to-row-data-with-formula-testrow
Sheet: Sheet1

Week | A | B | C
1 | 0.8131484180940385 | 0.3624008527327458 | 0.6500474934365557
2 | 0.2471462820864727 | 0.9521088227917931 | 0.02258123631307996
3 | 0.04915533068295241 | 0.7932123565728046 | 0.6031218603263024
4 | 0.6686806058276906 | 0.9113136595366038 | 0.3410750262792743
5 | 0.4973303695176841 | 0.1351258568514737 | 0.7561067010141707
6 | 0.5279477221341466 | 0.04254056429850372 | 0.1725794645919061
7 | 0.8506952202835771 | 0.9319435610424451 | 0.7792370845268906
8 | 0.05552173775094538 | 0.5584317427715275 | 0.6656994040303961
9 | 0.1896472865728516 | 0.4105898536631361 | 0.5998351091390335
10 | 0.6792240333274582 | 0.5421031256785478 | 0.7339280122595979
11 | 0.3942318093597432 | 0.4643843526601317 | 0.07399623941223954
12 | 0.2699108017331964 | 0.8697865403153173 | 0.03738104123830865
13 | 0.09020409446727062 | 0.1326529719837799 | 0.8496805879480163
14 | 0.4244866824665632 | 0.4459176808502279 | 0.607771556391705
15 | 0.2693941853666995 | 0.1109069800888132 | 0.6664428955752411
16 | 0.3952717160747925 | 0.2217569275402536 | 0.1389421844258898
17 | 0.1323100722109007 | 0.9082887847832364 | 0.06826267137912834
18 | 0.6921054770684603 | 0.6530471808313676 | 0.3677286877828712
19 | 0.2605235484816379 | 0.4119801848980327 | 0.7874000329551383
20 | 0.6337627686251821 | 0.4697505732740366 | 0.006752685174954642
21 | 0.7852478102168827 | 0.3536912315292557 | 0.6213247551525589
22 | 0.05462233285071605 | 0.510435063447094 | 0.3437385831485278
23 | 0.3008427398475879 | 0.4551615618306768 | 0.1286049223762671
24 | 0.5650396393568262 | 0.1994891430731736 | 0.007213787677984973
25 | 0.8475789838655956 | 0.9852883240555936 | 0.403822366230453
26 | 0.244003988816915 | 0.9818351319653138 | 0.8810623729657356
27 | 0.4516036599898747 | 0.4737545060829245 | 0.09032753260198145
28 | 0.05747338269700553 | 0.9701678819199868 | 0.4437649328733002
29 | 0.7280263643147846 | 0.0301296172474208 | 0.6575675682474444
30 | 0.9444509348410168 | 0.08330059344184937 | 0.8472519677924286
31 | 0.202761808387125 | 0.9733268185382431 | 0.03492234392528704
32 | 0.03489896120576308 | 0.6852190932171558 | 0.8749222174039843
33 | 0.7087880039543997 | 0.1951107790924127 | 0.9108056177099171
34 | 0.3415044020333169 | 0.315693371595791 | 0.1487056813413747
35 | 0.4709392082110853 | 0.6716608669523287 | 0.3675261207590934
Spreadsheet: 033765cd-1fd1-4663-9e3f-ed74446ac6bd
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
64270DO011_201209 Producer Price Indexes, Australia, Sep 2012
Released at 11:30 am (Canberra time) Fri 2 Nov 2012
Weighting Patterns for Stage of Production (SOP), Australia
 | Contents
 | Tables
 | 1 | SOP Preliminary demand – Products consumed as inputs into the production of Intermediate demand
 | 2 | SOP Intermediate demand – Products consumed as inputs into the production of Final demand
 | 3 | SOP Final demand – Products consumed with no further processing
 | More information available from the ABS website
 | Producer Price Indexes, Australia, Sep 2012
 | Summary
 | Explanatory Notes
 | Inquiries
 | For further information about these and related statistics, contact the National Information and Referral Service on 1300 135 070.
 | © Commonwealth of Australia 2012
Spreadsheet: 0a04d177-de68-4d69-8989-e86fb4d81705
Sheet: Tiny

TINY
General
Model name | 10AAS0LU00 - Tiny | 10AXS04500 - Tiny | 10AAS0LV00 - Tiny | [NAME]
Description | ThinkCentre M93P, 2GHz 4x256 KB, W7HP64, [NAME], 1x500GB + 8GB SATA III, (2x2), [NAME], 4 Year On-site | ThinkCentre M73, 2GHz 4x256 KB, W7HP64EN, [NAME], 1x500GB + 8GB SATA III, (1x1), [NAME], 4 Year On-site | ThinkCentre M93P, 2.9GHz 2x256Kb, W7HP64, 4.0GB, 1x500GB + 8GB SATA III, (2x2), [NAME], 4 Year On-site | ThinkCentre M73, 2.90GHz 3MB, W7HP64EN, 4.0GB, 1x500GB SATA II, HD 4400, (1x1), [NAME], 4 Year On-site
From: | $1,167.00* | $1,146.00* | $952.50* | $798.00*
Your price: | $778.00* | $764.00* | $635.00* | $532.00*
Main Features
Processor | Intel Core i7-4765T ( 2GHz 1200MHz ) | Intel Core i7-4765T ( 2GHz 1200MHz ) | Intel Core i5-4570T Processor ( 2.90GHz 1150MHz ) | Intel Core i3-4130T Processor ( 2.90GHz 1600MHz 3MB)
Operating system | Windows 7 Home Premium 64 | Windows 7 Home Premium 64 | Windows 7 Home Premium 64 | Windows 7 Home Premium 64
Graphics |  |  |  | Intel HD 4400
Memory | 8.0GB [NAME] 1600 MHz | 8.0GB [NAME] 1600 MHz | 4.0GB [NAME] 1600 MHz | 4.0GB [NAME] 1600 MHz
Pointing device | USB Optical Mouse | USB Optical Mouse | USB Optical Mouse | USB Optical Mouse
Hard Drive | 500GB + 8GB | 500GB + 8GB 5400 rpm | 500GB + 8GB | 500GB 7200 rpm
Network Card | Lenovo 11a/g/n Wi-Fi wireless | Lenovo 11a/g/n Wi-Fi wireless | Lenovo 11a/g/n Wi-Fi wireless | Lenovo 11a/g/n Wi-Fi wireless
Optical Drive | Bluetooth Version 4.0 | Bluetooth Version 4.0 | Bluetooth Version 4.0 | Bluetooth Version 4.0
Warranty | Four year | Four year | Four year | Four year
Form Factor | Tiny | Tiny | Tiny | Tiny
Operating System Language | EN:English | EN:English | EN:English | EN:English
RAM | SODIMM | SODIMM | SODIMM | SODIMM
Warranty Details | On-site | On-site | On-site | On-site
Ports | 2 Super Speed USB 3.01 integrated VGA port,2 High Speed USB 3.0 (front),Ethernet,Microphone/Headphone Jacks,Special High Speed USB 3.0 for ODD box,Display port,Microphone | 3 USB 2.0 (back)Microphone jack (front),Ethernet,1 Integrated VGA port (back),2 High Speed USB 3.0 (front),Headphone jack (front),Display port | Ethernet1 integrated VGA port,2 High Speed USB 3.0 (front),Microphone/[NAME],Special High Speed USB 3.0 for ODD box,2 Super Speed USB 3.0,Display port,Microphone | Microphone [NAME] (front)2 High Speed USB 3.0 (front),Display port,1 Integrated VGA port (back),Ethernet,Headphone jack (front),3 USB 2.0 (back)
Weight | 2.9 lbs( 1.32 kgs) | 2.9 lbs( 1.32 kgs) | 2.9 lbs( 1.32 kgs) | 2.9 lbs( 1.32 kgs)
Height | 7in( 179 mm) | 7in( 179 mm) | 7in( 179 mm) | 7in( 179 mm)
[NAME] | 1.35in( 34.5 mm) | 1.35in( 34.5 mm) | 1.35in( 34.5 mm) | 1.35in( 34.5 mm)
Depth | 7.1in( 182 mm) | 7.1in( 182 mm) | 7.1in( 182 mm) | 7.1in( 182 mm)
Spreadsheet: 196434d1354008442-extracting-a-string-before-a-space-namesexample-1-
Sheet: Sheet1

Name | First | Last
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31538

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080708 | 2008-07-08 | 2008 | 7 | 228673 | Cordless rotary hammer TE 6-A | 1 | 185.319999999999 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 77.5799999999999 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.83 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.83 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 337043 | Diamond cutter DC 230-S 110V box | 1 | 155.86 | 127404 | 31538
20080708 | 2008-07-08 | 2008 | 7 | 382573 | Angle grinder DCG 125-S 110V KL box | 1 | 125.95 | 127404 | 31538
Spreadsheet: 167789d1342104725-cut-and-paste-calculation-exampleexcelfile
Sheet: Ingredient

Check | compoundID | Ingredient name | amount
 | 1 | Ingredient #1 | 25gm
a | 1 | Ingredient #2 | 10gm
 | 1 | Ingredient #3 | 30gm
a | 2 | Ingredient #4 | 50gm
 | 2 | Ingredient #5 | 100gm
 | 3 | Ingredient #6 | 20gm
 | 3 | Ingredient #7 | 35gm
 | 3 | Ingredient #8 | 40gm
a | 3 | Ingredient #9 | 70gm
[NAME] in F2 =IFERROR(INDEX(B$2:B$10,SMALL(IF($A$2:$A$10="a", ROW($A$1:$A$9),""),ROW(A1))),"")
Spreadsheet: 36784d1234732191-give-location-of-cells-coordinates-coordinates
Sheet: Sheet5

 | 70 | 71 | 72 | 73 | 74 | 75 | X | Y
1 | 1001 | 1002 | 1003 | 1004 | 1005 | 1006 | 5 | 75 | 2006
2 | 3001 | 3002 | 3001 | 3001 | 3001 | 3001
3 | 4001 | 4002 | 4003 | 4004 | 4005 | 4006
4 | 5001 | 5002 | 5003 | 5004 | 5005 | 5006
5 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R34

Ime artikla
Spreadsheet: 274749d1383213184-finding-text-in-cells-and-return-a-value-from-other-cell-0a1_excel
Sheet: sheet with data

 | week 3 |  |  | week 2 |  |  | week 1
 | 30.10.2013 |  |  | 17.10.2013 |  |  | 10.10.2013
 |  | problem |  |  | problem |  | 10.10.2013 | problem
 |  | x |  |  | z |  | 10.10.2013
 |  |  |  |  |  |  | 10.10.2013 | t
 |  | z |  |  |  |  | 10.10.2013 | z
 |  |  |  |  |  |  | 10.10.2013
 | 31.10.2013 |  |  | 18.10.2013 |  |  | 11.10.2013
 |  | problem |  |  | problem |  | 11.10.2013 | problem
 |  | t |  |  |  |  | 11.10.2013 | b
 |  |  |  |  |  |  | 11.10.2013 | x
 |  | a |  |  |  |  | 11.10.2013 | a
 |  |  |  |  | t |  | 11.10.2013
 | 1.11.2013 |  |  | 19.11.2013 |  |  | 12.10.2013
 |  | problem |  |  | problem |  | 12.10.2013 | problem
 |  |  |  |  |  |  | 12.10.2013 | d
 |  | x |  |  | a |  | 12.10.2013
 |  | y |  |  |  |  | 12.10.2013
 |  |  |  |  |  |  | 12.10.2013
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 4Capital Costs

Table 5.2.31.  Capital Costs
Complete the areas shown in gray below.  Where shown, use pulldown menus to select options.  The spreadsheet will calculate the capital costs.
Alternative:
Project Administration ($):
Component | Unit Costa | Unit | Quantity | Total Cost
aUnit costs are in today's dollars, not future dollars. |  |  | Total Construction Cost:
 |  |  | Construction Contingency Cost:
 |  |  | Project Administration Cost:
 |  |  | Total Capital Cost:
Construction Contingency: | 0.1
Spreadsheet: 266939d1379868289-employee-schedule-help-hl-team-schedule-blank
Sheet: Sheet2

 |  |  |  |  |  |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 825825d1681559496-correction-of-the-indirect-timetable-formula-2023-draft-dailykode-1-
Sheet: FEBRUARY

 |  | DATE | 2023-02-01 00:00:00
GR. 1 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM
 | 1 | 111 | Jhon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 | 2 | 112 | [NAME]
 | 3 | 113 | Adalyn
 | 4 | 114 | [NAME]
 | 5 | 115 | Beverly
Spreadsheet: 168467d1342464679-sumproduct-function-and-condition-test
Sheet: Sheet2

 | A | B | C | D | E | F | G | H
1 | 8 | 10 | 13 | 20 | 9 | 26 | 5 | 16
2 | 23 | 7 | 7 | 15 | 28 | 24 | 12 | 25
3 | 20 | 21 | 5 | 28 | 20 | 21 | 12 | 3
4 | 18 | 6 | 30 | 4 | 20 | 19 | 5 | 3
5 | 9 | 11 | 13 | 16 | 29 | 3 | 26 | 9
6 | 8 | 3 | 13 | 4 | 14 | 25 | 20 | 5
7 | 28 | 15 | 8 | 29 | 4 | 24 | 8 | 10
8 | 13 | 15 | 23 | 29 | 25 | 15 | 26 | 18
9 | 8 | 10 | 28 | 23 | 30 | 6 | 22 | 13
10 | 25 | 9 | 21 | 10 | 11 | 7 | 26 | 25
Spreadsheet: a366d7d9-4f72-4611-bc91-ce54ea680321
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120608 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Authorizing the purchase of parcels of land identified as Tract Nos. 191,193,196, 221 in Kansas City, Platte County,
 | Missouri, for Airport Development, and the expendtiture of appropraited funds in the amount of $350,324.
Is this ordinance for the following: |  |  |  |  | New Construction
 | NOT APPLICABLE |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  |  | Yes
 |  |  |  |  |  |  | FY
 | If no, please detail the reasons why this project was not included and need for present funding request.
Please identify source of funds below.
 | Non-City source and amount.
 | Source of Funds:
 | Fiscal Year Funded
 | Amount of Non-City Funds: |  |  | $
 | City source and amount.
 | Acct #:
 | Name of Fund:
 | Fiscal Year Funded
 | Amount of City Funds: |  |  | $
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $
 | Estimated lifespan of project in years |  |  | $
 | Estimated annual operating and maintenance costs |  |  | $
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  |  | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | FY
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 706556d1606765002-data-comparison-and-aggregation-looking-for-help-copy-template
Sheet: analysis

ID | Acc Num |  |  | Value | totalValue | otherPercentage | otherCharge | My%Charged | MyCharge | MybrandCheaper? |  |  | Aggregated comparison required? | family pricing % | family pricing charge
111 | 1111 |  |  | 1133059.89 | 1133059.89
111 | 1112 |  |  | 3984.4 | 3984.4
222 | 1113 |  |  | 199959.2 | 199959.2
222 | 1114 |  |  | 716513.7 | 716513.7
222 | 1115 |  |  | 55676.77 | 55676.77
333 | 1116 |  |  | 38657.34 | 38657.34
333 | 1117 |  |  | 445112.3 | 445112.3
444 | 1118 |  |  | 121 | 121
444 | 1119 |  |  | 157763.62 | 157763.62
555 | 1120 |  |  | 612748.12 | 612748.12
555 | 1121 |  |  | 906128.44 | 906128.44
666 | 1122 |  |  | 5678224.49 | 5678224.49
777 | 1123 |  |  | 456034.94 | 456034.94
777 | 1124 |  |  | 123456.29 | 123456.29
888 | 1125 |  |  | 2509.43 | 2509.43
888 | 1126 |  |  | 75748.43 | 75748.43
888 | 1127 |  |  | 12745.31 | 12745.31
999 | 1128 |  |  | 123461.02 | 123461.02
999 | 1129 |  |  | 509000.2 | 509000.2
1000 | 1130 |  |  | 131575.33 | 131575.33
1000 | 1131 |  |  | 31040.95 | 31040.95
Spreadsheet: 775559d1649179453-array-formula-to-produce-cashflow-of-a-bond-frequency
Sheet: Sheet1

Principal | Interest | Frequnecy | Maturity | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00
100000 | 1000 | 1 | 2023-08-21 00:00:00
102000 | 1020 | 1 | 2023-11-01 00:00:00
104000 | 1040 | 1 | 2023-09-19 00:00:00
106000 | 1060 | 1 | 2023-02-11 00:00:00
102300 | 1023 | 1 | 2023-05-13 00:00:00
110000 | 1100 | 1 | 2023-01-22 00:00:00
111000 | 1110 | 1 | 2023-06-14 00:00:00
116000 | 1160 | 2 | 2023-02-01 00:00:00
118000 | 1180 | 1 | 2023-05-05 00:00:00
112100 | 1121 | 1 | 2023-01-18 00:00:00
122000 | 1220 | 1 | 2023-02-12 00:00:00
124000 | 1240 | 4 | 2023-06-15 00:00:00
126000 | 1260 | 1 | 2023-07-15 00:00:00
128000 | 1280 | 1 | 2023-09-26 00:00:00
151000 | 1510 | 1 | 2023-11-08 00:00:00
100000 | 1000 | 1 | 2023-01-17 00:00:00
152000 | 1520 | 2 | 2023-05-01 00:00:00
113900 | 1139 | 1 | 2023-06-14 00:00:00
142000 | 1420 | 1 | 2023-03-20 00:00:00
144000 | 1440 | 1 | 2023-11-22 00:00:00