tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 821218d1678517765-index-match-function-kt7-ans2
Sheet: Sheet1

Employee Name | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024
Chakrapani | 446 | 387 | 983 | 801 | 59 | 794 | 547 | 10 | 485 | 649 | 1000 | 1000 | 150 | 380 | 665 | 332 | 94 | 867 | 516 | 551 | 474 | 490 | 911 | 336
Minakshi | 569 | 519 | 616 | 57 | 313 | 642 | 545 | 862 | 68 | 225 | 92 | 909 | 255 | 101 | 94 | 875 | 168 | 531 | 235 | 831 | 363 | 215 | 513 | 967
Poornima | 721 | 280 | 142 | 535 | 297 | 660 | 55 | 896 | 492 | 718 | 402 | 910 | 163 | 156 | 470 | 984 | 620 | 351 | 485 | 365 | 236 | 361 | 140 | 129
Ratna | 825 | 989 | 792 | 592 | 721 | 151 | 361 | 710 | 254 | 617 | 766 | 849 | 376 | 315 | 111 | 144 | 926 | 361 | 924 | 277 | 223 | 889 | 300 | 987
Amarjeet | 922 | 148 | 918 | 88 | 219 | 137 | 336 | 371 | 128 | 560 | 173 | 512 | 637 | 997 | 474 | 489 | 491 | 716 | 205 | 560 | 444 | 99 | 700 | 288
Govinda | 289 | 641 | 133 | 777 | 948 | 430 | 317 | 896 | 75 | 735 | 316 | 211 | 489 | 365 | 42 | 678 | 865 | 80 | 532 | 801 | 611 | 495 | 983 | 948
Haroon | 526 | 469 | 646 | 522 | 818 | 337 | 649 | 219 | 116 | 313 | 519 | 816 | 206 | 206 | 891 | 433 | 262 | 490 | 658 | 51 | 23 | 331 | 728 | 823
Madhur | 125 | 569 | 143 | 500 | 818 | 596 | 988 | 315 | 987 | 284 | 41 | 248 | 493 | 521 | 729 | 463 | 950 | 230 | 564 | 682 | 897 | 934 | 91 | 249
Anupama | 178 | 80 | 966 | 78 | 629 | 523 | 345 | 857 | 773 | 861 | 70 | 623 | 18 | 914 | 471 | 81 | 603 | 119 | 147 | 151 | 521 | 294 | 933 | 510
Charyulu | 61 | 241 | 471 | 981 | 17 | 619 | 738 | 300 | 631 | 195 | 92 | 443 | 505 | 381 | 836 | 583 | 152 | 880 | 394 | 797 | 97 | 308 | 251 | 761
Meenakshi | 363 | 614 | 446 | 691 | 397 | 619 | 602 | 49 | 508 | 588 | 724 | 216 | 702 | 340 | 394 | 44 | 299 | 300 | 303 | 250 | 933 | 188 | 728 | 151
Parminder | 986 | 723 | 765 | 674 | 745 | 626 | 214 | 644 | 83 | 579 | 43 | 233 | 955 | 760 | 413 | 726 | 762 | 375 | 318 | 706 | 277 | 705 | 56 | 519
[NAME] | 948 | 929 | 731 | 248 | 561 | 142 | 395 | 122 | 449 | 413 | 778 | 749 | 236 | 300 | 81 | 813 | 69 | 519 | 953 | 111 | 819 | 516 | 558 | 63
 |  |  |  |  |  | Highest revenue |  |  |  |  |  | Highest revenue
 |  |  |  |  | TOP1 | Employee Name |  |  |  |  | TOP2 | Employee Name
ideally this should show 2011 |  |  |  |  |  | Year |  |  |  |  |  | Year
 |  |  |  |  |  | Highest revenue
 |  |  |  |  | TOP2 | Employee Name
 | RESULT Table |  |  |  |  | Year
 | Top | Revenue | Year | Emp Name
 | 1
 | 2
 | 3
Spreadsheet: 873119d1719544533-count-the-numbers-with-mutli-criteria-without-duplicate-sample_1
Sheet: Sheet2

System Code | Batch # | Host Name VM
Apple | [NAME] | VM1
Apple | [NAME] | VM2
Apple | [NAME] | VM3
Apple | [NAME] | VM4
Apple | [NAME] | VM5
Apple | [NAME] | VM6
Orange | [NAME] | VM1
Orange | [NAME] | VM2
Watermelon | [NAME] | VM1
Watermelon | [NAME] | VM1
Watermelon | [NAME] | VM1
Watermelon | [NAME] | VM2
[NAME] | [NAME] | VM1
[NAME] | [NAME] | VM2
[NAME] | [NAME] | VM3
[NAME] | [NAME] | VM4
 | De- duplicated | De-duplicated
System Code | Batch 1 # of VM | [NAME] of VM
Apple | 1 | 0
Orange | 1 | 1
Watermelon | 1 | 1
[NAME] | 3 | 1
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Lithium

Raw Material |  | Lithium
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 4.895
Total
Spreadsheet: 138764d1327887476-formulas-and-conditional-formatting-based-on-multiple-cell-values-and-criterias-final-takeoff
Sheet: MP-1

 |  |  | STOCK SHEET WIDTH |  |  |  |  |  | CALCULATE STIFFENERS?
 |  |  | STOCK SHEET HEIGHT
 |  |  |  |  |  |  |  |  | [NAME]?
 |  |  |  |  |  |  |  |  | [NAME]?
CLIENT: |  |  |  |  |  | MAT'L: |  |  |  |  |  | DATE
PROJECT: |  |  |  |  |  | FINISH:
COMMENTS | MK# | QTY | FACE | FACE | FACE | STRETCH | STRETCH | STRETCH | # | LIN FT | PERIMETER | SPECIAL NOTES  PER CUSTOMER REQUEST
 |  |  | WIDTH | HEIGHT | SQ.FT. | WIDTH | HEIGHT | SQ.FT. | STIFFENERS | STIFFENERS | FOOTAGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WIDTH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HEIGHT
3-COAT PE-CORE TOTALS:
Spreadsheet: 818106d1676589958-if-and-or-q-and-d-feb-with-summary-end
Sheet: 15th

1 | Defect ID | Unit ID | Unit Date | Prod Date | Act Date | Shift | Year | Serial | z | ID #1 | ID #2 | ID #3 | Product | Color #1 | Color #2 | Part | Location | Concern | [NAME] | Rank | Grid Label | Responsible Area | Responsible Cell | Recording User | Recording Area | Recording Cell | Recording Station | Defect Status | Root Cause | Root Cause User | Comments | sequence no | 1st | 2nd | 3rd | Date
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 230409d1366752980-help-deadline-to-meet-newbie-fairly-easy-one-auto-copy-data-from-sheet-to-sheet-tristancapp-investors-
Sheet: Fund 1

Date | Investor | Invesment | Fund | Investment Stage
Spreadsheet: 599678d1543247893-if-statement-additional-if-statement-examplegipsagg
Sheet: GIPS.Review.Template

TABLE 1: ACTUAL DATA
Date_MDYYYY | DTOVER01_Entry | DTOVER01_Exit | DTOVER02_Entry | DTOVER02_Exit | DateRange
2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2012-05-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2012-06-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2017-10-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2017-11-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2017-12-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2018-01-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00 | 2018-01-01 00:00:00 | 2099-01-01 00:00:00
2018-02-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00 | 2018-01-01 00:00:00 | 2099-01-01 00:00:00
TABLE 2: FINAL RESULT SHOULD BE
Date_MDYYYY | DTOVER01_Entry | DTOVER01_Exit | DTOVER02_Entry | DTOVER02_Exit | DateRange
2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00 |  |  | InRange
2012-05-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00 |  |  | InRange
2012-06-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00 |  |  | InRange
2017-10-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2017-11-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2017-12-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00
2018-01-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00 | 2018-01-01 00:00:00 | 2099-01-01 00:00:00 | InRange
2018-02-01 00:00:00 | 2012-01-01 00:00:00 | 2014-08-01 00:00:00 | 2018-01-01 00:00:00 | 2099-01-01 00:00:00 | InRange
Spreadsheet: 3a4e05f8-7c98-4f2b-8167-0275c63779a0
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
T A Jørgensen Transport AS | Toftenes | 4513 | Mandal
Holum Transport AS | [NAME] 660 | 4519 | Holum
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 737910d1624651842-nested-index-match-with-max-test
Sheet: Sheet1

Customer | Total | Country | Output Need
1065414 | 333.33 | Japan | Japan
1065414 | -4160 | Canada | Canada
1065414 | 4160 | US | Canada | Highest amount |  | Customer 1065414 has the highest invoice amount in Canada
1065414 | 432.84 | Canada | Canada
1065414 | 4995 | Canada | Canada
1001130 | 141500 | Japan | Japan
1001130 | 1122 | Canada | Canada
1001130 | 95600 | US | Japan | Highest amount |  | Customer 1001130 has the highest invoice amount in Japan
1001130 | 18570 | Canada | Canada
1001130 | 4748 | Canada | Canada
1001130 | 71236 | US | Japan | Highest amount
1001130 | 31450 | US | Japan | Highest amount
1019559 | 1494 | Canada | Canada
1019559 | 5398 | Canada | Canada
1019559 | 34100 | US | Japan | Highest amount
1019559 | 43485 | Japan | Japan
1019559 | 6250 | Canada | Canada
1019559 | 47260 | US | Japan | Highest amount
1029551 | 11227 | Canada | Canada
1029551 | 45450 | Canada | Canada
1029551 | 275000 | US | China | Highest amount
1029551 | 27900 | Japan | Japan
1029551 | 10500 | Canada | Canada
1029551 | 21845 | US | China | Highest amount
1029551 | 11888 | China | China
1029551 | 160195 | China | China
Spreadsheet: 474947d1470982871-timestamping-images-and-file-size-timestamp-test-file-1
Sheet: Tracking

Weekly Tracking |  | Today's Date: | 2016-09-08 00:00:00
Status
New
Processing
Pending
Closed
Cancelled
Spreadsheet: 465731d1465853706-sum-number-range-with-two-sets-of-criteria-listed-with-merged-cells-example-one
Sheet: Data

Created By | Application | # of SRs
[NAME] | Calls | 32
 |  | 46
 |  | 33
 |  | 26
 |  | 24
 |  | 33
 |  | 49
 |  | 26
 |  | 29
 |  | 30
 |  | 38
 |  | 38
 |  | 52
 |  | 31
 |  | 38
 |  | 32
 |  | 36
 |  | 36
 |  | 22
 | Emails | 29
 |  | 11
 |  | 10
 |  | 9
 |  | 5
 |  | 1
 |  | 5
 |  | 4
 |  | 6
 |  | 6
 |  | 8
 |  | 8
 |  | 8
 |  | 10
 |  | 6
 |  | 6
 |  | 6
 |  | 9
 |  | 2
 | Outgoing Calls | 1
 |  | 2
 |  | 1
 |  | 2
 |  | 2
 |  | 2
 |  | 4
 |  | 3
 |  | 1
 |  | 3
 |  | 1
 |  | 1
 | Outgoing Emails | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
[NAME] | Calls | 41
 |  | 54
 |  | 27
 |  | 27
 |  | 39
 |  | 26
 |  | 32
 |  | 20
 |  | 29
 |  | 31
 |  | 33
 |  | 24
 |  | 20
 |  | 46
 |  | 22
 |  | 32
 |  | 42
 |  | 32
 |  | 43
 | Emails | 17
 |  | 9
 |  | 3
 |  | 7
 |  | 3
 |  | 3
 |  | 5
 |  | 6
 |  | 10
 |  | 5
 |  | 6
 |  | 7
 |  | 5
 |  | 5
 |  | 9
 |  | 2
 |  | 11
 |  | 5
 |  | 3
 | Outgoing Calls | 1
 |  | 4
 |  | 1
 |  | 2
 |  | 3
 |  | 1
 |  | 2
 |  | 2
 |  | 6
 |  | 7
 |  | 2
 |  | 2
 |  | 4
 |  | 4
 |  | 1
 |  | 2
 |  | 1
 |  | 9
 | Outgoing Emails | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
[NAME] | Calls | 1
 |  | 2
[NAME] | Calls | 19
 |  | 5
 |  | 9
 |  | 14
 |  | 5
 |  | 8
 |  | 7
 |  | 9
 |  | 6
 |  | 8
 |  | 13
 |  | 13
 |  | 16
 |  | 9
 |  | 17
 |  | 15
 |  | 12
 |  | 10
 |  | 11
 | Emails | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 5
 |  | 1
 |  | 1
 | Outgoing Calls | 35
 |  | 79
 |  | 36
 |  | 25
 |  | 24
 |  | 28
 |  | 32
 |  | 27
 |  | 36
 |  | 37
 |  | 29
 |  | 39
 |  | 35
 |  | 20
 |  | 59
 |  | 17
 |  | 33
 |  | 12
 |  | 22
 | Outgoing Emails | 1
 |  | 1
Spreadsheet: 111873d1308138222-excel-2007-link-a-list-box-to-a-table-dashboard-business-activity-in-eurozone
Sheet: Calculations

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
21 | Mining & quarrying | Manufacturing | Electricity, gas & water supply | Construction | Distributive trades | Hotels & restaurants | Transport, storage & communication | Real estate, renting & business activities
Value added (EUR billion) |  |  |  |  |  |  |  |  | 0
Number of persons employed (1000) |  |  |  |  |  |  |  |  | 8
Average personnel costs (EUR 1 000 per employee) |  |  |  |  |  |  |  |  | 16
Spreadsheet: 119959d1314889220-how-to-count-the-number-of-cells-greater-than-zero-in-a-filtered-list-example
Sheet: Sheet1

 |  | Count Greater than Zero:
Client | Status of Loss | Status | Devt 1
A | Closed | Paid | 0
A | Closed | Outstanding | 0
A | Closed | Incurred | 0
B | Closed | Paid | 5275
B | Closed | Outstanding | 11200
B | Closed | Incurred | 16475
C | Open | Paid | 1367.19
C | Open | Outstanding | 14000
C | Open | Incurred | 15367.19
D | Closed | Paid | 17811.75
D | Closed | Outstanding | 994490.6
D | Closed | Incurred | 1012302.35
E | Open | Paid | 52145.14
E | Open | Outstanding | 3001673
E | Open | Incurred | 3053818.14
F | Open | Paid | 6755
F | Open | Outstanding | 2508305
F | Open | Incurred | 2515060
G | Open | Paid | 2071
G | Open | Outstanding | 87000
G | Open | Incurred | 89071
H | Open | Paid | 3443.5
H | Open | Outstanding | 99800
H | Open | Incurred | 103243.5
I | Closed | Paid | 1078.78
I | Closed | Outstanding | 250.49
I | Closed | Incurred | 1329.27
J | Open | Paid | 0
J | Open | Outstanding | 0
J | Open | Incurred | 0
K | Open | Paid | 2089
K | Open | Outstanding | 23850
K | Open | Incurred | 25939
L | Open | Paid | 0
L | Open | Outstanding | 1000050
L | Open | Incurred | 1000050
M | Closed | Paid | 1
M | Closed | Outstanding | 1
M | Closed | Incurred | 2
N | Open | Paid | 0
N | Open | Outstanding | 200000
N | Open | Incurred | 200000
O | Closed | Paid | 0
O | Closed | Outstanding | 0
O | Closed | Incurred | 0
P | Open | Paid | 173700
P | Open | Outstanding | 2326300
P | Open | Incurred | 2500000
Spreadsheet: 127299e7-75ae-40f3-a3f7-3c3fb5b5485d
Sheet: IRR1

IRR function: IRR(values, guess)
Period | 0 | 1 | 2 | 3 | 4 | 5
Cost |  | 95000
Benefit |  |  | 8000 | 8000 | 8000 | 108000
Total Cash Flow
IRR
Spreadsheet: 877842d1724785621-multiparameter-if-formula-needed-book1_2
Sheet: Instrument #1, #2, #3

 | Site:
 | Instrument #1: |  |  | Instrument #2: |  |  | Instrument #3:
 | Fluid TNC Count |  |  |  |  | [NAME]
 |  | #1 | #2 | %DIF | DIF |  | #1 | #2 | %DIF | DIF
 | 1 | 100 | 105 |  |  | 1
 | 2 | 19 | 26 |  |  | 2
 | 3 | 500 | 510 |  |  | 3
 | Mean: |  |  |  |  | Mean:
 |  | TEa = ± | 0.15 | if <28 ± | 4 |  | TEa = ± | 0.15 | if <28000± | 4000
 |  | Within 1/2 TEa? |  |  |  |  | Within 1/2 TEa?
 | Fluid TNC Count |  |  |  |  | [NAME]
 |  | #1 | #3 | %DIF | DIF |  | #1 | #3 | %DIF | DIF
 | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3
 | Mean: |  |  |  |  | Mean:
 |  | TEa = ± | 0.15 | if <28 ± | 4 |  | TEa = ± | 0.15 | if <28000± | 4000
 |  | Within 1/2 TEa? |  |  |  |  | Within 1/2 TEa?
 | ** "N/A" = above or below TEa %, but may or may not be within ± absolute difference value. See note below
Performed By: |  |  |  |  |  |  |  | Date:
Reviewed By: |  |  |  |  |  |  |  | Date:
Spreadsheet: 472672d1469702411-vlookup-based-on-a-criteria-account-client-wise
Sheet: Zakawdeen

NO. | IMEI | STATUS | CLIENT | PRICE | CLIENT PAID BY | CLIENT PAID ME | PAID DATE | REMARKS
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
 | TOTAL
 | TOTAL IMEIS DONE
 | BALANCE PAYABLE AS AT
Spreadsheet: 860819d1708838580-solutions-tracking-truck-status-moviments-delivered-ans2
Sheet: Hoja1

 |  |  |  |  | truck | status           8AM | status          10AM | status        12PM | status           14PM | status            15PM | status          16PM | status          17PM | %
 |  |  |  |  | truck1 | on Route | on Route | on Route | on Route | on Route | on Route | delivered
 |  |  |  |  | truck2 | on Route | on Route | on Route | delivered | - | - | -
 |  |  |  |  | [NAME] | on Route | on Route | on Route | on Route | on Route | delivered | -
 |  |  |  |  | truck4 | on Route | on Route | delivered | - | - | - | -
 |  |  |  |  | truck5 | delivered | - | - | - | - | - | -
 |  |  |  |  | truck6 | on Route | on Route | refused | - | - | - | -
 |  |  |  |  | truck7 | on Route | on Route | on Route | on Route | on Route | refused | -
 |  |  |  |  | truck8 | on Route | on Route | on Route | on Route | on Route | on Route | motivated
 |  |  |  |  | truck9 | on Route | motivated | - | - | - | - | -
 |  |  |  |  | truck10 | refused | - | - | - | - | - | -
Spreadsheet: 121381d1316020540-counting-formula-count-weekends-off-october
Sheet: Sheet4

Active Employees | 11 |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | 55 shifts
Sunday | 7 | 4 | Open | 6 | 5 | 4 | 4 | 4 | 5 | 5
Mon | 9 | 2 | Close | 6 | 6 | 4 | 4 | 4 | 6 | 6
Tue | 7 | 4 | Employees Available | 6 | 8 | 7 | 7 | 8 | 9 | 8
Wed | 8 | 3 | Open to Closers | 0 | 3 | 0 | 0 | 0 | 2 | 3
Thur | 7 | 4
Fri | 9 | 2
Sat | 8 | 3
Spreadsheet: 156255d1337243573-one-lookup-value-multiple-matches-book1
Sheet: Statement

[NAME]
Statement
Date
Address | Month Paid | Date Paid | Amount Paid | Other Income | Management Fee | Total
 | May
 | May
 | May
 | May
 | May
Total Income
Property Maintenance
Spreadsheet: 53df8e15-4552-4ac8-8425-33af2a546c70
Sheet: 8. Survey Image Database

Survey & Mapping
Req # | Description of Requirement | Response | Comments
Required Fields for Survey Image Database
SID.1 | Provide a Database/storage structure for survey images (CSMs, Plats of Surveys, etc…) that allows outside users access but doesn't disrupt Dodge County's existing workflows for survey database maintenance and updating. |  | MS Access is currently used to index survey images
SID.2 | Ability to maintain current file formats for survey documents |  | file formats in use are: tif/pdf
SID.3 | Ability to link survey images to PINs This should open up ability to track survey images by: address, owner name, PLSS location, ([NAME],quarter-quarter section) Plat Name, CSM Number, etc.
SID.4 | Ability for graphical search for survey images (i.e. similar to Washington County’s Survey Record Site http://maps2.co.washington.wi.us/Apps/plats/) This will require linking survey images to parcel polygons |  | currently have this ability in ACAD
SID.5 | Ability to track survey images by geographic location (Lat/Lon coordinates)
SID.6 | Ability to relate Parent/Child links with CSMs/Plats of Surveys,etc, the same as like with parcels
SID.7 | Ability to link recorded documents (deeds, easements, etc) to survey images
SID.8 | Ability to distinguish between plats of surveys and CSMs, Plats, etc…(for linking to [NAME] for recorded documents)
SID.9 | Ability to combine parameters listed above into one query
SID.10 | Interface this data to others
Spreadsheet: 712751d1610390673-need-formula-to-match-each-weeks-target-to-forward-volumes-restarting-each-week-stock-management-issue
Sheet: LEAD TIME CALCS

[NAME] | Week | SKU | Projected Opening stock | Projected receipts that week | Unfilled orders | Weeks before stock available |  | OP Stock | Inbound |  | OP Stock | Inbound |  | OP Stock | Inbound
Week 1 - Inbound projections made |  |  |  |  |  |  |  | Make 400 |  |  | Make 500 |  |  | Make 600
1 | 21-01 | SKU 1 | 0 | 90 | 400 | 2 |  | 0 | 90
2 | 21-02 | SKU 1 | 30 | 168 | 500 | 2 |  |  | 168 |  | 30
3 | 21-03 | SKU 1 | 119 | 170 | 600 | 5 |  |  | 170 |  |  |  |  | 119
4 | 21-04 | SKU 1 | 198 | 144 |  |  |  |  | 144
5 | 21-05 | SKU 1 | 236 | 46 |  |  |  |  | 46
6 | 21-06 | SKU 1 | 229 | 31 |  |  |  |  | 31 |  | 500 |  |  | 600
7 | 21-07 | SKU 1 | 224 | 31 |  |  |  |  | 31
8 | 21-08 | SKU 1 | 245 | 160 |  |  |  |  | 160
9 | 21-09 | SKU 1 | 266 | 0 |  |  |  |  | 0
10 | 21-10 | SKU 1 | 89 | 221 |  |  |  |  | 221
11 | 21-11 | SKU 1 | 199 | 136 |  |  |  |  | 136
Week 2 - Week 1 inbound adjusted
 |  |  |  |  |  |  |  | Make 400 |  |  | Make 538 |  |  | Make 600
1 | 21-01 | SKU 1 | 0 |  | 400 | 3 |  |  | 90
2 | 21-02 | SKU 1 | 52 | 168 | 538 | 4 |  |  | 130
3 | 21-03 | SKU 1 |  | 170 | 600 | 5 |  |  | 170
4 | 21-04 | SKU 1 |  | 144 |  |  |  |  | 144
5 | 21-05 | SKU 1 |  | 46 |  |  |  |  | 46
6 | 21-06 | SKU 1 |  | 31 |  |  |  |  | 31
7 | 21-07 | SKU 1 |  | 31 |  |  |  |  | 31
8 | 21-08 | SKU 1 |  | 160 |  |  |  |  | 160
9 | 21-09 | SKU 1 |  | 0 |  |  |  |  | 0
10 | 21-10 | SKU 1 |  | 221 |  |  |  |  | 221
11 | 21-11 | SKU 1 |  | 136 |  |  |  |  | 136
 |  |  | Need a "rolling" formula that calculates when sufficient stock will be available to meet any week's unfilled orders.
Spreadsheet: 844929d1696527124-timestamp-issues-test
Sheet: Sheet1

This is what it is exported as |  |  |  |  |  |  | Expected results
Timestamp |  |  |  |  |  |  | Date | Time
10/4/2023 12:06:53 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:06:53
10/4/2023 12:05:41 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:05:41
10/4/2023 12:05:10 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:05:10
10/4/2023 12:04:28 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:04:28
10/4/2023 12:03:25 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:03:25
10/4/2023 1:38:27 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 01:38:27
10/4/2023 12:15:33 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:15:33
10/4/2023 12:14:31 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:14:31
10/4/2023 12:13:24 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:13:24
10/4/2023 12:11:12 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:11:12
10/4/2023 12:10:51 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:10:51
10/4/2023 12:10:11 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:10:11
10/4/2023 12:09:10 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:09:10
10/4/2023 12:09:02 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:09:02
10/4/2023 12:07:57 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:07:57
10/4/2023 12:07:22 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:07:22
10/4/2023 12:21:00 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:21:00
10/4/2023 12:20:29 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:20:29
10/4/2023 12:19:52 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:19:52
10/4/2023 12:19:07 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:19:07
10/4/2023 12:18:49 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:18:49
10/4/2023 12:17:44 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:17:44
10/4/2023 12:17:07 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:17:07
10/4/2023 12:16:04 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:16:04
10/4/2023 12:16:40 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:16:40
10/4/2023 12:14:54 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:14:54
10/4/2023 12:31:08 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:31:08
10/4/2023 12:26:52 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:26:52
10/4/2023 12:26:09 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:26:09
10/4/2023 12:25:06 AM |  |  |  |  |  |  | 2023-10-04 00:00:00 | 00:25:06
Spreadsheet: 0aa1ac01-6e3e-49e4-909b-09d9aecd9749
Sheet: Sheet1

ID | site_location | apiary_number | POINT_X | POINT_Y
1 |  |  | 577573.793816 | 183596.539813
2 |  |  | 574942.24272 | 183671.946214
3 |  |  | 577793.133838 | 182003.744961
4 |  |  | 580438.178712 | 181305.243564
5 |  |  | 578141.590785 | 187401.255756
6 |  |  | 578533.174901 | 186088.919798
7 |  |  | 575538.085578 | 186882.671386
8 |  |  | 573685.99854 | 187041.421703
9 |  |  | 574871.334244 | 188544.258042
10 |  |  | 581655.264479 | 185845.502645
11 |  |  | 573114.497397 | 180299.824887
12 |  |  | 572617.079736 | 181220.576728
13 |  |  | 572320.74581 | 182151.911924
14 |  |  | 573241.497651 | 183347.830983
15 |  |  | 577792.340086 | 182998.580284
16 |  |  | 578056.923949 | 183559.498073
17 |  |  | 577739.423314 | 185072.917766
18 |  |  | 581348.347199 | 186290.003534
19 |  |  | 582322.015813 | 188724.175069
20 |  |  | 584068.269305 | 186406.420433