tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 356508d1415128906-countif-by-date-year-test-2
Sheet: Sheet1

Orig |  |  |  |  |  |  |  |  | Desired (2014)
LC Date | CD Date | Name | Amt | Med | LC (Month) | CD (Month) |  |  | Month | Count of CD | Sum of Amount |  | Med
2012-01-01 00:00:00 | 2012-01-04 00:00:00 | dsfs | 100 | Org |  |  |  |  | January | 3 | 3759 |  | Org
2012-01-02 00:00:00 | 2012-01-10 00:00:00 | dsfsd | 20 | Other |  |  |  |  | February | 1 | 23456
2012-02-01 00:00:00 | 2012-02-05 00:00:00 | rte | 180 | Print |  |  |  |  | March
2012-08-02 00:00:00 | 2012-08-08 00:00:00 | fsda | 150 | [NAME] |  |  |  |  | April
2013-01-03 00:00:00 | 2013-01-09 00:00:00 | sadf | 200 | TS |  |  |  |  | May
2013-01-04 00:00:00 | 2013-01-08 00:00:00 | dfsa | 140 | Other |  |  |  |  | June
2013-01-05 00:00:00 | 2013-01-08 00:00:00 | werw | 234 | Org |  |  |  |  | July
2013-02-06 00:00:00 | 2013-02-08 00:00:00 | sdafa | 324 | PS |  |  |  |  | August
2014-01-05 00:00:00 | 2014-01-07 00:00:00 | getfer | 6445 | PS |  |  |  |  | September
2014-01-08 00:00:00 | 2014-01-09 00:00:00 | hdfgsdg | 3425 | Org |  |  |  |  | October
2014-01-09 00:00:00 | 2014-01-11 00:00:00 | derate | 4325 | [NAME] |  |  |  |  | November
2014-02-03 00:00:00 | 2014-02-05 00:00:00 | retrd | 23342 | Print |  |  |  |  | December
2014-02-04 00:00:00 | 2014-02-08 00:00:00 | xfhf | 23456 | Org
2014-05-01 00:00:00 | 2014-05-02 00:00:00 | [NAME] | 32413 | TS
Spreadsheet: 57774d1257988789-pivot-table-question-test
Sheet: Raw Data

Session ID | Question 2: Where is your airline headquartered? | Question 1a | Question 1b | Question 1c
334957888 | Asia Pacific | 5 | 1 | 1
334959560 | Latin America/Caribbean | 4 | 4 | 3
334966533 | North America | 4 | 3 | 4
334990113 | North America | 3 | 1
334999525 | Europe | 2 | 2 | 2
335012524 | Middle-East-Africa | 3 | 4
335015028 | Latin America/Caribbean | 3 | 4 | 3
335016314 | Middle-East-Africa | 2 | 4 | 3
335017186 | Europe | 3 | 2 | 3
335021027 | Middle-East-Africa | 5 | 5 | 3
335028073 | Europe | 3 | 4 | 3
335028478 | Middle-East-Africa | 5 | 2 | 1
335384051 | Middle-East-Africa | 3 | 4 | 3
335415505 | Europe | 3 | 3 | 3
335509402 | Asia Pacific | 3 | 4
335522007 | Europe | 4 | 1 | 3
335548723 | Europe | 4 | 3 | 3
335785180 | Asia Pacific | 4 | 3 | 4
335836945 | Europe | 2 | 2 | 3
335916317 | Latin America/Caribbean | 3 | 5 | 2
336188618 | Europe | 3 | 3 | 3
336397670 | Latin America/Caribbean | 5 | 4 | 2
Spreadsheet: 16e00fe3-a209-454e-9562-9b8d0a702559
Sheet: ตรวจความสะอาด

แบบบันทึกการตรวจความสะอาดร่างกายและเสื้อผ้าของนักเรียน
โรงเรียนสามแยกบางคูลัด  ชั้นประถมศึกษาปีที่ 5  ภาคเรียนที่ 1 ปีการศึกษา 2555
[NAME]………วันที่..….…เดือน…………………………พ.ศ. 2555    นักเรียนทั้งหมด……………คน
เลขที่ | [NAME]. | ชื่อ - สกุล |  | รายการ |  |  |  |  |  |  |  |  |  |  | คิดเป็นร้อยละ | หมายเหตุ
 |  |  |  | ตา | หู-ซอกหู | จมูก | ฟัน | ปาก - ลิ้น | ผม-ศีรษะ | มือ-เล็บ | ใบหน้า-ผิวหนัง | เสื้อผ้า | ถุงเท้า-รองเท้า | รวม
1 | 1127 | ด.ช.ณัฐวุฒิ | ณรงค์ศักดิ์
2 | 1133 | ด.ญ.มรกต | นาคผ่อง
3 | 1134 | ด.ญ.พัชรินทร์ | นพขำ
4 | 1135 | ด.ญ.อุบลวรรณ | สุวรรณวงศ์
5 | 1136 | ด.ญ.นุจรีย์ | ศรีพิพัฒน์
6 | 1159 | ด.ช.วรากร | จั่นเพชร
7 | 1202 | ด.ช.ชลชาติ | วงษ์สุวรรณ
8 | 1224 | ด.ช.ธัญชลิต | ห้วยหงษ์ทอง
9 | 1270 | ด.ช.อนันตสิทธิ์ | ผาลา
10 | 1272 | ด.ช.จิรานุพงษ์ | สายจันทร์
11 |  | ด.ช.ปภาวิน | รัตนจันทร์
12 |  | ด.ญ.ฐณิสา | อ่อนราช
13 |  | ด.ญ.กัญญาลัก | สายกระสุน
14 |  | ด.ญ.ภัทราภรณ์ | ประทุมวงษ์
15 |  | ด.ช.วัชรินทร์ | ชัยภูมูล
16 |  | ด.ช.พชรพล | จันทร์ทอง
 |  |  | *** หมายเหตุ | /  =   สะอาด |  |  |  | 0  =  ไม่สะอาด
 |  |  |  |  |  |  | ลงชื่อ....................................................ผู้บันทึก
 |  |  |  |  |  |  | ( นายภานรินทร์  ปัญญาจรัสกุล)
 |  |  |  |  |  |  | ครูประจำชั้น
แบบบันทึกการตรวจความสะอาดร่างกายและเสื้อผ้าของนักเรียน
โรงเรียนสามแยกบางคูลัด  ชั้นประถมศึกษาปีที่ 6  ภาคเรียนที่ 1 ปีการศึกษา 2555
[NAME]………วันที่..….…เดือน…………………………พ.ศ. 2555    นักเรียนทั้งหมด……………คน
เลขที่ | [NAME]. | ชื่อ - สกุล |  | รายการ |  |  |  |  |  |  |  |  |  |  | คิดเป็นร้อยละ | หมายเหตุ
 |  |  |  | ตา | หู-ซอกหู | จมูก | ฟัน | ปาก - ลิ้น | ผม-ศีรษะ | มือ-เล็บ | ใบหน้า-ผิวหนัง | เสื้อผ้า | ถุงเท้า-รองเท้า | รวม
1 | 1108 | ด.ญ.ลินดา | ศรีพิพัฒน์
2 | 1179 | ด.ช.ชลันธร | ทายา
3 | 1264 | ด.ช.เจษฎา | ผิลา
4 | 1267 | ด.ช.ชาญชัย | สกุลศรี
5 | 1319 | ด.ช.อนุชา | อัปมาโท
6 | 1320 | ด.ช.ธนาคม | อรัญภูมิ
แบบบันทึกการตรวจความสะอาดร่างกายและเสื้อผ้าของนักเรียน
โรงเรียนสามแยกบางคูลัด  ชั้นประถมศึกษาปีที่ 6  ภาคเรียนที่ 1 ปีการศึกษา 2555
[NAME]………วันที่..….…เดือน…………………………พ.ศ. 2555    นักเรียนทั้งหมด……………คน
เลขที่ | [NAME]. | ชื่อ - สกุล |  | รายการ |  |  |  |  |  |  |  |  |  |  | คิดเป็นร้อยละ | หมายเหตุ
 |  |  |  | ตา | หู-ซอกหู | จมูก | ฟัน | ปาก - ลิ้น | ผม-ศีรษะ | มือ-เล็บ | ใบหน้า-ผิวหนัง | เสื้อผ้า | ถุงเท้า-รองเท้า | รวม
1 | 1108 | ด.ญ.ลินดา | ศรีพิพัฒน์
2 | 1179 | ด.ช.ชลันธร | ทายา
3 | 1264 | ด.ช.เจษฎา | ผิลา
4 | 1267 | ด.ช.ชาญชัย | สกุลศรี
5 | 1319 | ด.ช.อนุชา | อัปมาโท
6 | 1320 | ด.ช.ธนาคม | อรัญภูมิ
 | *** หมายเหตุ  / = สะอาด    0 = ไม่สะอาด |  |  |  |  |  |  | ลงชื่อ............................................ผู้บันทึก
 |  |  |  |  |  |  |  | ( นางรัชนี   [NAME])
 |  |  |  |  |  |  |  | ครูประจำชั้น
Spreadsheet: 138461d1327672986-data-validation-new-quote-program
Sheet: Sheet1

 | Name | [NAME] |  |  |  |  | Job No: |  |  |  |  | [NAME] |  | R/Roll |  | Flat
 | Adddress |  |  |  |  |  | Sales Rep |  |  |  |  | [NAME] |  | D/Sided |  | Gable
 | Suburb |  |  |  |  |  | Date: |  |  |  |  | [NAME] |  | F/Deck |  | Dome
 | Mobile |  |  |  |  |  |  |  |  |  |  | [NAME] |  | S/Span |  | Pyramid
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Design | [NAME] | Length | Total Sqm | Rate | Material | Total
 | Flat | 4 | 6 |  | 200 | S/Span |  |  |  |  |  |  |  | R/Roll
 | Gable | 4 | 10 |  | 250 |  |  |  |  |  |  |  |  | D/Sided
 |  |  |  |  |  |  |  |  |  |  |  |  |  | F/Deck
 |  |  |  |  |  |  |  |  |  |  |  |  |  | S/Span
Spreadsheet: 119140d1314216925-how-to-identify-mark-rows-in-a-column-that-equals-a-sum-solver_sum
Sheet: Sheet1

FIND EXACT TOTAL OF | 4152873.5 | BELOW |  | 0.04999999981373549 | Object function
START HERE | 2328204.25 | 1
 | 2122745.6 | 0 |  |  |  | Solver is not installed by default in excel. If Solver is not found under "Tools"
 | 1039171.85 | 1 |  |  |  | you will have to go to "Add-Ins" and install Solver (Excel 2003).
 | 750000 | 0
 | 723604.09 | 0
 | 693019.73 | 0
 | 668570 | 0
 | 370128.39 | 0
 | 369103.2 | 1
 | 256501.05 | 0
 | 163027.2 | 0
 | 157637 | 0
 | 94819.87 | 1
 | 79196.77 | 1
 | 78525 | 1
 | 78525 | 0
 | 72948 | 0
 | 55000 | 1
 | 50000 | 0
 | 38680.26 | 0
 | 31000 | 1
 | 25806.39 | 0
 | 22116.54 | 1
 | 19108.42 | 0
 | 18733.14 | 1
 | 17195.8 | 1
 | 9099.84 | 1
 | 8550 | 1
 | 4390 | 0
 | 3375 | 0
END HERE | 2157.19 | 1
Spreadsheet: 833843d1687276453-conditional-formatting-of-multiple-conditions-based-on-a-date-in-another-cell-master-project-template-for-help-2-solution-etaf-3-
Sheet: Project Log

Type | Contract Date | Client Name | Contact | Internal Project Name | Project Address/Legal | Project Manager | Status/Phase | COA | Permitting | ACC | Demo | Notes
Remodel & Addition | 2022-11-30 00:00:00 | meg |  | 1860's Dog Trot Farmhouse |  | Erin | Schematic Design | No | No | No | No
ADU | 2023-02-21 00:00:00 | jeremiah |  | Carleen |  | [NAME] | Schematic Design | Yes | Yes | No | No
Remodel | 2023-03-02 00:00:00 | art |  | Nicholson  Pinehaven |  | [NAME] | Preliminary | No | No | No | Yes
ADU | 2023-05-16 00:00:00 | southerly |  | Southerly  Martin |  | [NAME] | NCC Preliminary | Yes | Yes | No | No
Commercial | 2023-06-05 00:00:00 | port |  | Port  Art Center |  | [NAME] | Feasibility | No | No | No | No
Other | 2023-06-01 00:00:00 | shannon |  | Test Project |  | Shannon | Feasibility | No | No | No | No
Commercial | 2023-06-04 00:00:00 | calder |  | Calder |  | Heather | Preliminary | No | No | No | No
Spreadsheet: 53606d1253554917-multiple-criterias-in-spreadsheet-example-of-what-is-required
Sheet: Sheet1

MASTER LIST |  |  |  |  |  | CLIENT LIST
ID | Acct # | Amount |  |  |  | ID | Acct # | Amount
11111 | AAA | 500 |  |  |  | 11111 | AAA | 1000
11111 | AAA | 1000 |  |  |  | 11111 | AAA | 500
22222 | BBB | 5000 |  |  |  | 22222 | BBB | 5000
22222 | ZZZ | 2500 |  |  |  | 22222 | ZZZ | 2500
33333 | CCC | 500 |  |  |  | 33333 | CCC | 500
44444 | DDD | 2500 |  |  |  | 44444 | DDD | 2500
44444 | DDD | 1500 |  |  |  | 44444 | EEE | 1500
55555 | GGG | 1500 |  |  |  | 66666 | FFF | 200
55555 | GGG | 1500 |  |  |  | 66666 | FFF | 200
Summary Totals |  | 16500 |  |  |  |  |  | 13900 |  | 2600
 |  |  |  |  |  |  |  |  |  |  | [NAME] should explain what is the difference and why.
Basically, at the end of the day, I need a summary and details spreadsheet providing me with the following issues:  Master List Amt Total vs. Client List Amt Total -- The difference broken down in a detail spreadsheet(s) --- Could be something like [Perfect Match Spreadsheet] and [Amounts don't match] [ID and amounts match but Acct # is different][Remaining members from Master List] and [Remaining members from Client List]
As an added note, I've tried a VLOOKUP function, but doesn't seem to be the right way of doing this… see example of what happens on the next sheet.  Please help.  I've been working on this for 5 days now..
Spreadsheet: 866017d1712942250-counting-unique-values-across-2-columns-sample
Sheet: Sheet1

Solution | Households
yard + fence | Smith
yard only | [NAME]
yard only | [NAME]
yard only | [NAME]
yard + fence | Morrison
yard + fence | Kimpton
yard only | Jacobs
yard only | Jacobs
yard only | Jacobs
fence only | Leni
yard only | [NAME]
yard only | [NAME]
Unique homes
Unique homes yard + fence | ??
Unique homes yard only | ??
Unique homes fence only | ??
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: FG Feb 20

 | Daily |  |  | Last day of month
 |  |  |  | Jan | 800 | 504
1 | 1222 | 800 |  | Feb | 800 | 562
2 | 1249 | 800 |  | Mar | 800 | 794
3 | 1265 | 800 |  | Apr | 800 | 794
4 | 1259 | 800 |  | May | 800 | 673
5 | 1255 | 800 |  | Jun | 800 | 857
6 | 1268 | 800 |  | Jul | 800 | 954
7 | 1303 | 800 |  | Aug | 800 | 1036
8 | 1268 | 800 |  | Sept | 800 | 982
9 | 1297 | 800 |  | Oct | 800 | 1008
10 | 1330 | 800 |  | Nov | 800 | 913
11 | 1312 | 800 |  | Dec | 800 | 800
12 | 1340 | 800 |  | Jan | 800 | 683
13 | 1283 | 800 |  | Feb | 800 | 818
14 | 1281 | 800 |  | Mar | 800 | 759
15 | 1280 | 800 |  | Apr | 800 | 1066
16 | 1290 | 800 |  | May | 800 | 1170
17 | 1304 | 800 |  | Jun | 800 | 931
18 | 1311 | 800 |  | Jul | 800 | 1034
19 | 1357 | 800 |  | Aug | 800 | 971
20 | 1368 | 800 |  | Sep | 800 | 987
21 | 1315 | 800 |  | Oct | 800 | 855
22 | 1273 | 800 |  | Nov | 800 | 1041
23 | 1310 | 800 |  | Dec | 800 | 1062
24 | 1342 | 800 |  | Jan | 800 | 1139
25 | 1325 | 800 |  | Feb | 800 | 1291
26 | 1363 | 800 |  | Mar
27 | 1371 | 800 |  | April
28 | 1314 | 800 |  | May
29 | 1291 | 800 |  | June
30 |  | 800 |  | July
31 |  | 800
Total
Spreadsheet: 377403d1423963045-how-to-generate-non-repeating-random-numbers-in-a-column-wihtout-vb-random-sort-1-to-10-no-repeats-or-vba
Sheet: Sheet1

Numbers | Rand
3
2 |  |  |  | Press F9 to refresh the [NAME] number column
4 |  |  |  | Then click on the Data Tab to show those Icons
7 |  |  |  | Now click on B2 and then on the A to Z sort Icon.
8
6 |  |  |  | No [NAME] needed.  No repeated numbers from 1 to 10.
5 |  |  |  | [NAME].
10
1
9
Spreadsheet: 291835-automatically-copy-a-row-of-data-from-one-sheet-to-another-routsheet
Sheet: 1043

RO# | OWNERS NAME | TAG | ADVISOR | [NAME] OF WORK | PROMISE TIME | 10 | 12 | 2 | 4 | DISPATCH TIME
74032 | BATWINSKI | 65 | 1026 | HEATER BOX | SOP B/O
74837 | CARMAX | 620 | 1026 | SOP-SHOCK-DUE IN THURSDAY | 1.23.14
74912 | SMET | 634 | 1026 | LIST | 1.23.14
74837 | CARMAX | 620 | 1026 | SOP | 1.23.14
74724 | RIVAS | 71 | 1013 | SES
Spreadsheet: john_hodge__16250__MANCINI SUMMARY
Sheet: MATL - Lateral

MANCINI Take-off and Pipeline
[NAME] of Materials
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Contractor Supplied |  |  | 0
Elbow |  |  |  | Size (O.D.) | qty | unit |  | Deg |  |  | Gr |  |  | Amount | Unit |  | Total | 717.583333333343
 |  | Elbow |  | 12 | 1 | ea. |  | 23 |  |  | B |  |  | 245.0833333333333 | ea. |  | 245.0833333333333
 |  | Elbow |  | 8 | 2 | ea. |  | 45 |  |  | B |  |  | 146.25 | ea. |  | 292.5
 |  | Elbow |  | 8 | 1 | ea. |  | 90 |  |  | B |  |  | 180 | ea. |  | 180
Pipe |  |  |  | Size (O.D.) | qty | unit |  |  | wall |  | f p b | Gr |  | Amount | Unit |  | Total | 43726.9904955556
 |  | FBE  0.375 wall, X 42 |  | 16 | 1760 | ft |  |  | std |  | f | 42 |  | 24.2928560677352 | ft |  | 42755.42667921395
 |  | FBE  0.375 wall |  | 12 | 20 | ft |  |  | 0.375 |  | f | b |  | 30.15663875566054 | ft |  | 603.1327751132109
 |  | FBE  0.322 wall |  | 8 | 20 | ft |  |  | 0.322 |  | f | 60 |  | 18.42155206142197 | ft |  | 368.4310412284394
Tees (Reducing) |  |  |  | Run     x | qty | unit |  | Branch |  |  | Gr |  |  | Amount | Unit |  | Total | 259.7222222222226
 |  | tee reducing |  | 12 | 1 | ea. |  | 8 |  |  | 42 |  |  | 259.7222222222222 | ea. |  | 259.7222222222222
Valves - Ball |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  | W/F |  |  |  | Amount | Unit |  | Total | 17130
 |  | Valves - Ball |  | 12 | 1 | ea. |  | 600 |  | F |  |  |  | 10230 | ea. |  | 10230
 |  | Valves - Ball |  | 8 | 1 | ea. |  | 600 |  | F |  |  |  | 6900 | ea. |  | 6900
Flanges |  |  |  | Size (O.D.) | qty | unit |  | ANSI | wall | W/F |  |  |  | Amount | Unit |  | Total | 500
 |  | Flange |  | 12 | 1 | ea. |  | 600 | std | W |  |  |  | 350 | ea. |  | 350
 |  | Flange |  | 8 | 1 | ea. |  | 600 | std | W |  |  |  | 150 | ea. |  | 150
Bolt-up & Gaskets |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  |  |  |  |  | Amount | Unit |  | Total | 330
 |  | Bolt-up & Gaskets |  | 12 | 2 | sets |  | 600 |  |  |  |  |  | 112 | ea. |  | 224
 |  | Bolt-up & Gaskets |  | 8 | 2 | sets |  | 600 |  |  |  |  |  | 53 | ea. |  | 106
Valves - Check |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  | End |  |  |  | Amount | Unit |  | Total | 620
 |  | [NAME] |  | 8 | 1 | ea. |  | 600 |  | F |  |  |  | 620 | ea. |  | 620
Reducers |  |  |  | Run     x | qty | unit |  | Branch |  |  | Gr |  |  | Amount | Unit |  | Total | 125
 |  | reducer |  | 16 | 1 | ea. |  | 12 |  |  | 42 |  |  | 125 | ea. |  | 125
TDW Items |  |  |  | Size (O.D.) | qty | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 8600
 |  | [NAME] flange |  | 18 | 1 | ea. |  |  |  |  |  |  |  | 4000 | ea. |  | 4000
 |  | [NAME] flange |  | 24 | 1 | ea. |  |  |  |  |  |  |  | 4600 | ea. |  | 4600
Spreadsheet: 1acdd4ea-eca2-4b65-88f6-21f22d3525b4
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
UOSMS | Test | UOSMS | Osmolality, Serum | Osmolality, S | [NAME] | Serum Gel Tube: SGT |  |  | 2 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 2 mL | 0.25 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | 275-295 mOsm/kg | Monday through Sunday; Continuously | 1 day | 1 day | 1 | 83930 |  |  |  |  | Rochester
UOSMS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
UOSMS | Result | UOSMS | Osmolality, S | Osmolality, S | Numeric |  |  |  |  | mOsm/kg |  |  |  |  |  |  |  |  |  | 2692-2 | Osmolality:Osmol:Pt:Ser/Plas:Qn:
Spreadsheet: 803208d1667314840-formula-to-vlookup-and-search-book6-2-aligw
Sheet: Sheet1

Source 1 | Result |  |  |  |  | Source 2
Welbeeing 05 2022 -   qwerty Name Surname |  |  |  |  |  | asdfgh Name Surname
Welbeeing 05 2022 -asdfgh Name Surname |  |  |  |  |  | qwerty Name Surname
Welbeeing 05 2022 -987654 Name Surname |  |  |  |  |  | 123456 Name Surname
 |  |  |  |  |  | 987654 Name Surname
 |  |  |  |  |  | qazwsx [NAME]
 |  |  |  |  |  | uklyhn Name Surname
Spreadsheet: e7f12f97-c85b-4870-8b9a-6bf364b8109e
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | To establish appropriations for Jackson County
 | COMBAT funding to investigate homicides.
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax) |  |  |  |  |  |  |  |  |  | 2340
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2006-07 |  |  | FY 2007-08
 | General Fund
 | Special Revenue |  |  |  | 428487 |  |  | 0
 | Enterprise
 |  |  | Total: | $ | 428487 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | This program is funded 100% by Jackson County using passed through federal grant money.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2006-07 |  |  | FY 2007-08
 | General Fund
 | Special Revenue |  |  |  | 428487 |  |  | 0
 | Enterprise/Other
 |  |  | Total: | $ | 428487 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | The Byrne JAG grant provides one-time funding that will be used to upgrade crime lab equipment.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
 | This will serve the citizens of Kansas City by upgrading Police equipment used to conduct forensic investigations.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 29132d1223967131-formula-to-allocate-points-to-positions-in-a-race-test2121
Sheet: Sheet1

 | I can't understand why you have given SAME points to the range 3-24 and above 25.
 | if you want to chage the points you can just change the last "2" in the formula
 | and as you are very new, just check your formula wheather its working correctly in all the conditions ( I mean points are given correctly)
Sno | Name | Rank | Points
1 | [NAME] | 1
2 | Charly | 2
3 | [NAME] | 3 |  |  |  |  | IF(C6=1,25, IF(C6=2,24, IF(AND(C6>=3,C6<=24),2, IF(C6>=25,2,""))))
4 | Holly | 9 |  |  |  |  | IF(C6=1,25, IF(C6=2,24, IF(AND(C6>=3,C6<=24),2, IF(C6>=25,1,""))))
5 | Marck | 10
6 | [NAME] | 12
7 | [NAME] | 13
8 |  | 15
9 |  | 16 |  |  |  |  | 1st place = 25 points
10 |  | 19 |  |  |  |  | 2nd place = 24
11 |  | 20 |  |  |  |  | down to 24th place = 2 points
12 |  | 13 |  |  |  |  | 25th place and lower= 2 points
13 |  | 24
14 |  | 25
15 |  | 36
16 |  | 40
17 |  | 56
18 |  | 50000
19 |  | 20000
Spreadsheet: 725772d1616849931-monthly-to-cusotm-date-report-sample-3-
Sheet: DataFeeding

Total |  |  |  |  |  |  |  |  |  | 2149.750000000008 |  | 5159.400000000015 |  |  |  |  |  |  |  |  | 480
Date | Product / Model Name | Leather | Color | Size | Unit Sold | Status | Sell Price | [NAME] | Unit Cost | DHL Cost | Handling Charges | Amazon Fees | PPC Cost | Total Cost | Net Sales | Zohaib Commision | After Zohaib Commision | Date of Return | Amazon Comm on Return | [NAME] after return | Ship Return Charges | DHL Cost | Handling Chges | Total Return Charges | Profit / Loss
 |  |  |  |  |  |  |  | 0.19 |  | 0.05 | 0.02 |  |  |  |  | 5 |  |  | 0.0175 |  | 4 | 0.05 | 0.02
2020-09-15 00:00:00 | ALVA |  | BLACK | XL | 1 | Sold | 50 |  |  | 6.45 |  | 15.48 |  |  |  |  |  |  |  |  | 0
2020-09-15 00:00:00 | HEDDA |  | RED | L | 1 | Sold | 75 |  |  | 4.95 |  | 11.88
2020-09-16 00:00:00 | HEDDA |  | RED | M | 1 | Sold | 30 |  |  | 4.95 |  | 11.88
2020-09-16 00:00:00 | ALVA |  | BLACK | XL | 1 | Sold | 20 |  |  | 6.45 |  | 15.48
2020-09-19 00:00:00 | ANELLI |  | COGNAC | XL | 1 | Sold | 99 |  |  | 4.95 |  | 11.88
2020-09-22 00:00:00 | EVRARD |  | BROWN |  | 1 | Sold | 129 |  |  | 6.45 |  | 15.48
2020-09-23 00:00:00 | HEDDA |  | RED | L | 1 | Sold | 99 |  |  | 4.95 |  | 11.88
Spreadsheet: 43977d1242655747-sum-multiple-rows-based-on-criteria-spread-across-multiple-rows-and-columns-sampledatarevenueanalysis
Sheet: Sheet1

OAC | Customer | Type | Description | 2008-01-01 00:00:00 | 2008-02-01 00:00:00
10000692 | ANZ553 | 33 | removed | -89.66 | -139.7
10000692 | ANZ553 | 36 | removed | -28.81 | -63.03
10000696 | ANZ553 | 33 | removed | -881.49 | -1310.04
10000696 | ANZ553 | 36 | removed | -318.89 | -394.72
10000703 | HAR104 | 31 | removed |  | -156.51
10000703 | HAR104 | 36 | removed |  | -96.17
10000713 | JOH333 | 31 | removed | -345.86 | -387.78
10000713 | JOH333 | 36 | removed |  | -56.91
10000721 | LLO550 | 31 | removed | -2435.13 | -2363.79
10000721 | LLO550 | 32 | removed | -43.7 | -34.96
10000721 | LLO550 | 33 | removed | -666.95 | -924.94
10000721 | LLO550 | 36 | removed
10000724 | [NAME] | 31 | removed | -0.94 | -2.57
10000728 | LLO550 | 31 | removed | -2055.55 | -2252.51
10000728 | LLO550 | 32 | removed | -175.45 | -140.36
10000728 | LLO550 | 33 | removed
10000797 | CSO001 | 32 | removed | -1336.5
No Customers | 5 | 5
No. new customer |  | 1
New customer value |  | -63.03
Lost to competitor no.
Value lost
Lost - closed no |  | 1
Lost - closed value
Downtrading no. |  | 2
Downtrading value
Uptrading  no. |  | 0
Uptrading vlaue
Spreadsheet: 526102d1499116300-multiple-criteria-within-date-range-and-matching-value-within-row-s666-excelforum
Sheet: BeforeSheet2

Date of Measurement | Identifier | Measurement | Row which measurement matches Identifier and [NAME] within date range from BeforeSheet1
2015-01-10 00:00:00 | ABC123 | 1.2
2015-03-01 00:00:00 | ABC123 | 3.4
2015-04-01 00:00:00 | ABC123 | 5.2
2015-01-12 00:00:00 | ABC456 | 3.4
2015-01-10 00:00:00 | ABC456 | 7.2
2015-12-11 00:00:00 | ABC456 | 5
2015-12-10 00:00:00 | ABC456 | 3.3